Re: growth metrics

From: Taral Desai <taral.desai_at_gmail.com>
Date: Tue, 8 Jan 2013 10:32:36 -0600
Message-ID: <CAO4+9HXDAdBcsVN3bt6jSj9-KccW_2ND8EaM+s0bV4qoj5=ovA_at_mail.gmail.com>

You can use linear regression using regr_* functions to predict growth. I am currently working on this for space forcasting.

On Mon, Jan 7, 2013 at 9:40 AM, oracledba <oracledba71_at_gmail.com> wrote:

> All,
> In my shop we do collect database growth info every 1st of a month.In
> addition to that we do collect all tablespace's growth info everyday and
> also stores file system's used and free space info everyday.
>
> The table has
> servername,dbname,tsname,filename,allocatedspace,freespace,date columns and
> populated everyday.
> The filesystem storage info table has
> dbname,servername,allocatedspace,freespace,mountpoint,date columns and
> populated everyday.
>
> I would like to report database growth weekly like
> week1,week2,week3,week4,monthy,quarterly,yearly and estimate for the next
> quarter and project when to order storage.
>
> any help would be appreciated.
>
> Thanks
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 

Thanks & Regards,
Taral Desai


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

Received on Tue Jan 08 2013 - 17:32:36 CET