How to calculate size of table including size of its indexes too.

Hi Guys,

I am trying calculate size of table including size of its indexes too. i am using below script to do so.

select a.owner,a.table_name,sum(b.bytes/1024/1024) AS SIZES,a.partitioned from dba_tables a,dba_segments b
where a.table_name=b.segment_name
and table_name ='FND_USER'
GROUP BY a.owner,a.table_name,a.partitioned

But i do not think this will give me size of indexes too. i do not see any column in dba_segments which relate tables with its indexes.

Any idea on this?

--

Thanks,
Hansraj

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 22 2008 - 10:39:01 CST