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
|
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