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.
[EMAIL PROTECTED]
-----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: [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).
