Home » RDBMS Server » Server Administration » Actual Size Oracle Database Size
Actual Size Oracle Database Size [message #51118] Mon, 29 April 2002 00:50 Go to next message
kimm
Messages: 3
Registered: April 2002
Junior Member
How to Calculate actual Database Size,
Whether to calculate only physical file size including CTL,log and DBF size or
the data tablespace size,Including temp,data,tools tablespace.
Pls explain.

kimm
Re: Actual Size Oracle Database Size [message #51176 is a reply to message #51118] Mon, 06 May 2002 06:39 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
It all depends on how you define 'database size'.

When I report to my management, there are 2 things I give

1. The sum of the physical size of all the file - named 'Allocated Space'
2. The sum of the used space of all tablespaces except TEMP and RBS. Add to this the ACTUAL size of TEMP and RBS. (The reason this was done was, we have Temp at 8 GB and may be only 100 KB used when running the report. So I add 8 GB. Same with RBS). - named 'Used Space'.

Usually, used space is 60-95% of the allocated space.

Hope this helps you.
Previous Topic: Oracle parameter
Next Topic: Error when re-creating CONTROL-file
Goto Forum:
  


Current Time: Wed Dec 25 10:49:48 CST 2024