In article <u9XfAPEq9GA.207_at_upnetnews05>, darussell_at_msn.com says...
> 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?
Ummmm....wouldn't this occur when either A) the rollback runs out of
extents or B) when the rollback tablespace runs out of space? If you
are refering to SNAPSHOT TOO OLD, then good luck!
Received on Mon Jul 06 1998 - 19:57:46 CDT
