I think the bytes column in dba_segments can give the desired information.

Gurmohan
www.freemath.info


------------------------------------------------------------------------------------------------------------

-----Original Message-----
From: NUTAN
[mailto:oracledba-ezmlmshield-x25999017.[Email address protected]
Sent: Thursday, June 30, 2005 11: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