Re: How to calculate size of table including size of its indexes too.
- From: "hansraj sao" <hansrajsao@xxxxxxxxx>
- To: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- 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..
Thanks,
Hansraj
On 1/22/08, Bradd Piontek <piontekdd@xxxxxxxxx> 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
Other related posts: