Re: trending growth, next increment

Nothing to do with math question asked but if you have RMAN repository you can consider a short note I posted couple days ago. There is a way to get past trend data.

http://www.pythian.com/blogs/318/using-rman-repository-for-database-growth-trend

On 11/29/06, Charles Schultz <sacrophyte_at_gmail.com> wrote:
> 10g introduced an object growth trend package. Unfortunately, it was
> horribly broken and I have not checked recently to see if they cleaned it
> up, yet. In the meantime, I have been using linear regression which works
> pretty good. We keep a repository of all tablespaces and build nightly
> reports. You always have to watch out for the exceptions, though. =)
>
> As our approach is rather hacked, I would be interested to hear what others
> are using.
>
>
> On 11/29/06, Bob <orcl_at_comcast.net > wrote:
> > Is there a way to find the trending growth (next increment) difference
> > between a defined list of values ie
> >
> > 1 , 2, 3, 4, 5 -- the next increment would be 1
> > 5,4,3,2,1 -- the next increment would be -1
> > 2,4,6,8,10 -- the next increment would be 2
> > 20,15,25,10,30 -- the next increment would be 10
> >
> > I dont want to subtract base values, so if the base value were lower
> > than the previous value, the lower value would re establish the counter.
> >
> > I would use to get trending growth of tablespaces, in this example over
> > a 5 month period
> >
> > Thanks
> > Bob
> >
> > --
> > "Oracle error messages being what they are, do not
> > highlight the correct cause of fault, but will identify
> > some other error located close to where the real fault lies."
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
>
> --
> Charles Schultz

-- 
Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l