Real size of an index?

From: Arkady Moreynis <webmaster_at_price.ru>
Date: Mon, 24 Aug 1998 20:57:27 +0300
Message-ID: <webmaster-2408982057270001@wmaster.price.ru>

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 Received on Mon Aug 24 1998 - 12:57:27 CDT