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: trending growth, next increment

Re: trending growth, next increment

From: Job Miller <jobmiller_at_yahoo.com>
Date: Wed, 29 Nov 2006 07:19:34 -0800 (PST)
Message-ID: <20061129151934.36411.qmail@web53904.mail.yahoo.com>

i don't think the question was asking about object growth, but trending in general.  

From the 10.2 docs, you can interpolate/extrapolate via linear regression using SQL and some middle-school math.  

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/functions132.htm

there are tons of statistical SQL functions in the db for this type of analysis.

----- Original Message ----
From: Charles Schultz <sacrophyte@gmail.com>
To: orcl@comcast.net
Cc: oracle-l <oracle-l@freelists.org>
Sent: Wednesday, November 29, 2006 9:23:59 AM
Subject: 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@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


 
____________________________________________________________________________________
Want to start your own business?
Learn how on Yahoo! Small Business.
http://smallbusiness.yahoo.com/r-index
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 29 2006 - 09:19:34 CST

Original text of this message

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