RE: Next Extent Failure Notification for Locally Managed Tablespaces

From: Shawn Ferris <shawn_at_virtualsmf.net>
Date: Thu, 24 Jun 2004 16:04:55 -0600 (MDT)
Message-ID: <11312.168.215.22.23.1088114695.squirrel@mail.virtualsmf.net>

> I searched at the old Oracle-L archives ( http://www.fatcity.com/ ),
> year 2003, word "autoallocate" in all fields and found a thread on the
> subject from last year. I will take the liberty of copying one of my
> posts from that thread, confirming that your code should be correct:

That's the logic I followed when designing the query.. I think I pulled it (the logic.. unfortunately, not the query.. or maybe fortunately) out of the Oracle manual.. and I tested it fairly thoroughly. The only thing that wasn't clear was oracles interpretation of a MB.. (1024 * 1024 vs. 1024 * 1000)

This is actually part of a bigger script that I use to monitor extents and adds a threshold. (Segment can't extend 5 times.. etc) So, I know well ahead of time that the segment is outgrowing the tablespace. I usually run it once a day, assuming something wont extend more than the threshold, in a single day.

Shawn

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 24 2004 - 16:50:48 CDT