Top Undo Users
- From: Shivaswamy / ಶಿವಸ್ವಾಮಿ <shivaswamykr@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 5 Sep 2009 07:37:57 -0400
Hello.
I am interested to know who had been top UNDO users - say in the past 24
hours(who may have already logged out). We do not seem to have any ASH views
to get this info. Do we?
Currently I am using log off trigger to capture 'undo change vector size'
from v$sesstat.
Thanks for your input, in advance.
Shiva
PS: I'm on 10GR1.
Other related posts:
- » Top Undo Users - Shivaswamy / ಶಿವಸ್ವಾಮಿ
