Home » RDBMS Server » Performance Tuning » Table actual size (oracle 10g)
Table actual size [message #563191] Thu, 09 August 2012 07:09 Go to next message
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 #563192 is a reply to message #563191] Thu, 09 August 2012 07:17 Go to previous messageGo to next message
Michel Cadot
Messages: 59109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Explain the second method.
Define "actual data size"; do you include Oracle overhead?

Regards
Michel
Re: Table actual size [message #563193 is a reply to message #563192] Thu, 09 August 2012 07:18 Go to previous messageGo to next message
savugar
Messages: 33
Registered: February 2012
Member
I saw the below lines in one link.

"Oracle thumb rule says (actual space required for a table + 30 % space) will calculate the original space requirement for a table."
Re: Table actual size [message #563199 is a reply to message #563193] Thu, 09 August 2012 08:24 Go to previous messageGo to next message
Michel Cadot
Messages: 59109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which link?
And is this what you define as "actual data size"?
Isn't the link saying it is the "space requirement for a table"?

Regards
Michel

[Updated on: Thu, 09 August 2012 08:25]

Report message to a moderator

Re: Table actual size [message #563201 is a reply to message #563199] Thu, 09 August 2012 09:50 Go to previous messageGo to next message
savugar
Messages: 33
Registered: February 2012
Member

http://dbarajabaskar.blogspot.in/2012/02/oracle-table-fragmentation-causing.html

I also not agree the 2nd method. However I just want to confirm this.
Re: Table actual size [message #563202 is a reply to message #563201] Thu, 09 August 2012 09:53 Go to previous messageGo to next message
BlackSwan
Messages: 22786
Registered: January 2009
Senior Member
>I also not agree the 2nd method. However I just want to confirm this.
then you are free to ignore it & not use it.
Re: Table actual size [message #563206 is a reply to message #563201] Thu, 09 August 2012 10:30 Go to previous message
Michel Cadot
Messages: 59109
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: get AWR report data
Next Topic: How to determine slowness in I/O from AWR?
Goto Forum:
  


Current Time: Wed Sep 17 09:13:59 CDT 2014

Total time taken to generate the page: 0.11777 seconds