Re: how to found the tablespace usage of index

You can use dba_segments to tell you how much space any database object is using.

e.g.

select segment_name,sum(bytes),tablespace_name from dba_segments
where segment_type = 'INDEX'
group by segment_name,tablespace_name
/

Hope this helps,

Allan

Tony PKBoy wrote:

> refer to the oracle adm. book, there is a table 'sys.index_stats' have the
> information of index, but it is empty.
>
> is any command like 'analyze table ...' that can update the 'dba_tables' ,
> user_tables, etc. for the table 'sys.index_stats' ?
>
> Or, can anyone teach me how to found the tablespace usage of each index in a
> database?

Received on Sun Sep 20 1998 - 10:15:29 CDT