RE: Actual space used per table

Ranko

>Where is the rest ?

It depends... some possibilities are...

First. From the 8 blocks you should remove the header blocks (i.e. header block, free list blocks, ASSM header blocks and extent map blocks). If you use free list management at least 1. If you use ASSM at least 3.

Second. If you have deleted rows, more than PCTFREE free space is available in the blocks.

Third. If you have multiple free lists or ASSM *and* you didn't insert the data with a single session, the inserts were probably spread over many blocks. Therefore the blocks are not full.

Forth. Each block contains, for its internal management, different structures. You should remove at least 100-150 bytes per block. If you specified many ITLs this can be much more...

Fifth. I don't remember right now... but there are for sure other possibilities ;-)

HTH
Chris

New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: Zürich (11-Oct), Hamburg (13-Oct), München (20-Oct), Basel (25-Oct),

         Frankfurt (27-Oct), Bern (8-Nov), Düsseldorf (23-Nov), Stuttgart (13-Dec)

--
http://www.freelists.org/webpage/oracle-l