Re: Tracking when users rollback

You could poll the v$sesstat every couple of minutes and get a diff between the rollbacks number between sessions. If you get an increase in rollbacks dump the table to a file. My gnumetrics application can easily be configured to trigger an alert when a rollback occurs and eventually it will be able to do what I descibed above. However you might just want to bookmark the site I'm trying to get the newest version out soon which has a number of improvments over the version that is currently posted.

-Ethan

http://www.gnumetrics.com

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Fri Jul 21 2000 - 00:00:00 CDT