Jared, David, Listers, Another very useful method that I have used in the past is the Ratio Modeling Technique. It is a low-precision method, but it is better than no-precision. Craig Shallahamer et al., wrote a paper on it within the Oracle context. I am sure there are many more out there, but I wanted to mention this, just in case you have not seen it. If you do a Google search on the keyword "Ratio Modeling Technique", you should get it.
Cheers, Gaja --- [EMAIL PROTECTED] wrote: > In a nutshell: > > Collect stats from dbms_free_space once a week, save > them in a table. > > Once a month, load the stats into another database > for calculation. > > Run them through a Perl filter to create a summary > table by tablespace. > > Use Oracle's Linear Regression functions to make a > prediction of future > usage at the end of the year, middle of next year, > and end of next year. > > LR is also used to predict the current usage based > on past space. The > difference between the actual and the prediction is > used to adjust future > predictions. > > It ain't perfect, but it's fairly accurate. > > Jared > > > > > > David Wagoner <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 08/11/2003 02:24 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject: Capacity Planning Methods? > > > How do you guys collect capacity planning metrics, > such as DB size? > Do you use StatsPack, Oracle OEM, others? I'm > interested in an efficient > method to track DB growth in GB month over month. > > Best regards, > David B. Wagoner > Database Administrator > > ===== __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
