Help - Search - Members - Calendar
Full Version: Resizing of Database
Oracle DBA Forums > Oracle > Oracle Forum
Francisco Riccio
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:

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:

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).
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2016 Invision Power Services, Inc.