Oracle-L: Re: Capacity Planning Methods?

From: <Jared.Still_at_radisys.com>
Date: Mon, 11 Aug 2003 15:24:23 -0800
Message-ID: <F001.005CA247.20030811152423@fatcity.com>

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 <dwagoner_at_arsenaldigital.com> Sent by: ml-errors_at_fatcity.com
08/11/2003 02:24 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Jared.Still_at_radisys.com

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: ListGuru_at_fatcity.com (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). Received on Mon Aug 11 2003 - 18:24:23 CDT