Re: trending growth, next increment

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

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