Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Actual space used per table

From: Ranko Mosic <ranko.mosic@xxxxxxxxx>
To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 2 Sep 2005 12:02:39 -0400

Hi all, 
I am using ave_row_len as calculated by analyze ; 
<ave_row_len> * <number of rows > . 
 How much overhead should I add ? My tests show that 2000 bytes per block as 
unaccounted for. 
  
4251 rows = 65536 bytes

ave_row_len = 10

4251 * 10 = 42510

Data is in 8 blocks.

2878.25 is overhead per block: 820 bytes is PCTFREE ( 10 % of block size ).

Where is the rest ? 

Please advise. 

  Thanks, Ranko.

Other related posts:

RE: Actual space used per table

Re: Actual space used per table