One method is to do this:

select sum(bytes) from dba_extents where owner=<owner> and segment_name=index_name;

That will tell you how much space Oracle has acquired for that index.

if you need to know exactly how much space is used by data, there is a fairly involved query that takes all the incidental stuff into account. I can probably track it down somewhere.

-----Original Message-----
From: NUTAN
[mailto:oracledba-ezmlmshield-x25999017.[Email address protected]
Sent: Thursday, June 30, 2005 10:43 AM
To: LazyDBA Discussion
Subject: Space occupied by each index


Is there a query to find out how much space in Index tablespace is occupied
by each index?



Nutan



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page