| Actual Size Oracle Database Size [message #51118] |
Mon, 29 April 2002 00:50  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
