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@xxxxxxxxx> 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@xxxxxxxxx> 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@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 -- Best regards, Alex Gorbachev The Pythian Group Sr. Oracle DBA http://www.pythian.com/blogs/author/alex/ http://blog.oracloid.com -- //www.freelists.org/webpage/oracle-l