| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DB Sizing
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Senthil Kumar
Sent: Tuesday, February 24, 2004 6:42 AM
To: oracle-l_at_freelists.org
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |