Re: trending growth, next increment

  • From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
  • To: orcl@xxxxxxxxxxx
  • Date: Wed, 29 Nov 2006 08:23:59 -0600

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@xxxxxxxxxxx> 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."

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






--
Charles Schultz

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2006