Thanks Connor, that is a lot faster. I think I will go with the idea of just watching for any dramatic drops in DBA_FREE_SPACE. I have everything tied down pretty tight but if a single object on a near empty tablespace started to grow uncontrollably I wouldn't pick it up till tablespace hit 75% or so or the next time I review my daily reports. This way I will get notified a bit sooner.
- Ethan -----Original Message----- Sent: Thursday, February 28, 2002 11:23 AM To: Multiple recipients of list ORACLE-L dba_segments is a view on sys_dba_segs which is: all "normal" segments union all all temp segs union all all rollback segs the last two of which we rarely care about when it comes to checking space etc. You can get (some) gains by creating your own view on just the "normal" segs hth connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
