FreeLists / oracle-l / Re: Actual space used per table

[Ranko Mosic <ranko.mosic@xxxxxxxxx>]

Yes, thanks all. 
It is 2 bytes per row for row directory that made up for most of the missing 
space.
 rm.

 On 9/2/05, Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote: 
> 
> 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<http://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)
>