How to calculate size of table including size of its indexes too.
- From: "hansraj sao" <hansrajsao@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, "hansraj sao" <hansrajsao@xxxxxxxxx>
- Date: Tue, 22 Jan 2008 11:39:01 -0500
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
Other related posts:
