Re: Actual space used per table
- From: Ranko Mosic <ranko.mosic@xxxxxxxxx>
- To: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
- Date: Fri, 2 Sep 2005 14:26:32 -0400
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)
>
Other related posts:
