| Table actual size [message #563191] |
Thu, 09 August 2012 07:09  |
 |
savugar
Messages: 33
Registered: February 2012
|
Member |
|
|
Which is the correct method to calculate actual data size in a table? becaue when I serach in google, I saw the below line.
"Oracle thumb rule says (actual space required for a table + 30 % space) will calculate the original space requirement for a table."
Method 1:
actual space = num_rows*avg_row_len
Method 2:
actual space = (Num of rows in a table) * (Avg_row_len) + ((Num of rows in a table) * (Avg_row_len)* 0.3)
[Updated on: Thu, 09 August 2012 07:18] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Table actual size [message #563206 is a reply to message #563201] |
Thu, 09 August 2012 10:30  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You stil didn't tell us what you mean by "actual data size"?
Without this definition any formula has a value of "UNKNOWN" (in the database logical sense).
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
