- Original Message -----
From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
To: M P <mpasha98_at_hotmail.com>
Sent: Monday, August 28, 2000 1:32 PM
Subject: Re: HOW TO FIND THE TABLES SIZES?
> Use this, or some variation to fit your particular needs:
> select segment_name "TABLE NAME", suM(bytes) from dba_segments
> where segment_type='TABLE'
> group by segment_name;
>
> This will give you the number of bytes in each table. You can do the
same
> for indexes, etc.
>
> HTH,
> Ruth
>
> ----- Original Message -----
> From: M P <mpasha98_at_hotmail.com>
> To: <oracledba_at_lazydba.com>
> Cc: <mpasha98_at_hotmail.com>
> Sent: Monday, August 28, 2000 12:16 PM
> Subject: HOW TO FIND THE TABLES SIZES?
>
>
> >
> >
> > Hi All:
> >
> > We are running Oracle 8.1.6 on HP-UX.
> >
> > How can I find the actual data in a Table. I need to generate a
> > report which show the actual size of the data in each table to
> > monitor the growth on a weekly basis. Our database is
> > about 100 gb but actual data is about 55 GB.
> >
> > Any body has any scripts or tools to watch the growth /size of each
table
> > and the size of the database.
> >
> > Any comments or suggestions and help are greatly appreciated.
> >
> > TIA
> > RGDS
> > MP
> >
> >
> >
> >
> > Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
> >
> > Share information about yourself, create your own public profile at
> > http://profiles.msn.com.
> >
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to
oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Mon Aug 28 2000 - 12:55:13 CDT
