I also grab freespace from dba_free_space, dump it into a table, and watch the deltas there, too. It helps for watching less predictable object growth, like perhaps with an index. Although my procedure is tablespace-oriented, so it won't give detail as to exactly what's doing all the growing.
If you'd like, I could post the smallish 68-line procedure and the table create that I use to do this. There are perhaps better ways of doin g this, but it works for me in 8.1.7 on dictionary managed tablespaces. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] > Sent: Monday, August 11, 2003 4:49 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Capacity Planning Methods? > > > 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: Jesse, Rich 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).
