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.

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

Francisco,

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).