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