RE: Capacity Planning Methods?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 11 Aug 2003 13:49:24 -0800
Message-ID: <F001.005CA22E.20030811134924@fatcity.com>

David

    I analyze the tables each week primarily to populate NUM_ROWS in USER_TABLES. I use ANALYZE TABLE because that works better in 8.1.6. Then I save the data to a separate table along with the date I did it. The primary rows are schema_name (if there is more than one schema of interest), date, num_rows, chained_rows, blocks. Whatever suits your purposes. Then I can go back and see the pattern of growth over time.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, August 11, 2003 4:24 PM
To: Multiple recipients of list ORACLE-L

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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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 - 16:49:24 CDT