Jul 9 2008, 06:07 PM
Hi everyone, i have a problem, a client is having its hd to 99% of full, so i have been asked how much gigabytes they need extra for being normal for a good time.
I want to know for where i can start, what views etc?
Thank you very much.
Jul 9 2008, 07:40 PM
You need to start with capacity planning. Here are the concepts:http://www.dba-oracle.com/concepts/databas...inistration.htm
First, get the growth rate from historical data (statspack or AWR), and exprapolate from there as to future disk capacity. They have spreadsheets for that:http://www.dba-oracle.com/monitoring_tablepack.htm
Jul 9 2008, 07:49 PM
Disk is cheap, I would get at least a 100 gig mirrored set of high-quality disks.
You want to see how much free space exists within each tablespace, and you query the dba_free_space view for this.
Once you attach the new disk, use the "alter tablespace xxx add datafile xxx" syntax to extend the tablespaces (unless it's using ASM, of course).