Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Table growth - disk sizing

Re: Table growth - disk sizing

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 22 Aug 2005 17:00:20 -0700
Message-ID: <bf4638050822170060b62946@mail.gmail.com>


I use dba_space to gather space stats on objects, once per week.

Not exact, but has served well enough the past few years to give a reasonable estimate of growth rates.

Jared

On 8/22/05, Ranko Mosic <ranko.mosic_at_gmail.com> wrote:
>
> Hi all,
> I need to estimate table growth. Any ideas except standard select
> segment_name, sum(bytes)
> from dba_segments
> group by segment_name;
> and likes, done every day to extrapolate growth ?
>
> Any experiences with alter table table_name monitoring; etc.
>
> Regards, Ranko.
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 22 2005 - 19:02:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US