How to calculate size of table including size of its indexes too.
Date: Tue, 22 Jan 2008 11:39:01 -0500
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
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?
http://www.freelists.org/webpage/oracle-l Received on Tue Jan 22 2008 - 10:39:01 CST