RE: DB Sizing
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Feb 2004 08:39:35 -0500
The short answer is you have to make an estimate for the initial load and
growth for every table in your application. One you have the table row
counts you can estimate the table and index sizes. You will need to allow
overhead for growth of each tablespace, for sort (temp tablespace), and for
transaction support (rollback tablespace).
The overhead also needs to consider any planned application additions.
Besides space for the database itself you need space for at least one set of
OS level full file backups and space to hold export files.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Senthil Kumar
Sent: Tuesday, February 24, 2004 6:42 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: DB Sizing
Hi,
I'm a new DBA.
I want to know how do i size my database. Any doc's are available for this.
One of my customer is asking me to give a detailed report for his database
sizing.
Do anybody have any checklist or any formula for sizing the db. I'm using
8.1.7.
TIA
Ram
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
