Re: preemptive rollback maintanance?

From: David <darussell_at_msn.com>
Date: Sun, 5 Jul 1998 19:37:14 +0100
Message-ID: <u9XfAPEq9GA.207@upnetnews05>

Not easily, but you could write a script that checks dba_rollback_segs / dba_extents / dba_free_space to see if a rollback sgement is about to hit max extents or the is not enough room for it to extend. Then check v$rollstat for active tranactions in that rollback segment. I think Enterprise Manager has an event for segments reaching threshholds.

Regards
David Russell

Steve Haynes wrote in message ...
>Hi All,
>Is there a way (oracle 8) to monitor how close a transction
>is to running out of rollback space?
>Steve
>--
>"The floggings will continue until morale improves."
>
Received on Sun Jul 05 1998 - 13:37:14 CDT