Re: How to calculate size of table including size of its indexes too.
Date: Tue, 22 Jan 2008 12:31:27 -0500
yeah, but this that case i will only get size of particular index.
I wanted know if there is any way be get table size+ its indexez size in on scripts.
its seems i need to write small procedure..
On 1/22/08, Bradd Piontek <piontekdd_at_yahoo.com> wrote:
> That is because there isn't one. You'll need to join dba_indexes with
> dba_segments based on a segment_type of 'INDEX' to make that jump.
> hansraj sao wrote:
> > 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,
> > 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
-- Thanks, Hansraj -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 22 2008 - 11:31:27 CST