Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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