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

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..

Thanks,
Hansraj

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,
> 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
> >
>

-- 
Thanks,
Hansraj

--
http://www.freelists.org/webpage/oracle-l