Re: Real size of an index?

Try
DBMS_SPACE.UNUSED_SPACE
and DBMS_SPACE.FREE_BLOCKS

as these can tell you how many blocks are actually used and how many are still free

In article <webmaster-2408982057270001_at_wmaster.price.ru>,   webmaster_at_price.ru (Arkady Moreynis) wrote:
> Hi all,
>
> Can anyone suggest how to calculate the REAL disk space occupied by an index?
>
> I doesn't mean just to sum up the sizes of extents occupied by the index.
> I'm interested in the space occupied INSIDE the extent (because as a
> performance-oriented person I'm trying to keep only 1 large extent per
> object).
>
> The only idea I came up with is a multiplying number of index_leaf_blocks
> (from dba_indexes) by db_block_size which could be a reasonable
> approximation.
>
> But maybe someone knows a better way?
>
> Regards,
> Arkady
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 25 1998 - 07:01:34 CDT