Re: Monitoring Growth Rates of all Objects

Richard,

I wrote a pl/sql package which uses the dba_extents view and groups the sum of the bytes by owner, segment_type, and segment_name. The pl/sql runs once a week, and I capture the bytes, number of extents, and growth rates. Also, look at the dbms_space package to see if there is anything there that may be of value to you.

Phil Cook Received on Tue Mar 17 1998 - 00:00:00 CST