Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Actual space used per table

Actual space used per table

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Fri, 2 Sep 2005 12:02:39 -0400
Message-ID: <367369f105090209025a6dedf4@mail.gmail.com>


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.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 02 2005 - 11:04:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US