RE: How do I find out the size of a index

[Whittle Jerome Contr NCI]

Title: RE: How do I find out the size of a index

Roger,

Try DBA_EXTENTS instead. Something like below:

SELECT SUBSTR(TABLESPACE_NAME,1,16) "Tablespace",
  SUBSTR(OWNER,1,9) "Owner", 
  SUBSTR(SEGMENT_NAME,1,30) "Index",
  SUBSTR(sum(BLOCKS * 8),1,16) "Size K"
FROM DBA_EXTENTS
WHERE segment_type = 'INDEX'
Group By TABLESPACE_NAME, OWNER, SEGMENT_NAME
ORDER BY 1, 2, 3;

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145

-----Original Message-----
From:   Roger Xu [SMTP:[EMAIL PROTECTED]

Hi,

I can use "select blocks*8 from dba_tables where table_name='ABC'"
to find out the size of a table.
How do I find out the size of a index? I do not see a column BLOCK in
dba_indexes.

Thanks,

Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337