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: goran bogdanovic <goran00_at_gmail.com>
Date: Wed, 29 Nov 2006 15:53:49 +0100
Message-ID: <6d0a3ba80611290653v2013a3c5r95518b15b92f0e05@mail.gmail.com>


daily snapshot (or as you like):

insert into db_growth_tbl
select file_name, file_id, tablespace_name, bytes/1048576 size_MB, trunc(sysdate) snap_date
from dba_data_files;

use sql analytical functions to process the results on weekly, monthly, quarterly, yearly basis...:-)

On 11/29/06, Alex Gorbachev <gorbyx_at_gmail.com> wrote:
>
> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 29 2006 - 08:53:49 CST

Original text of this message

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