Top Undo Users

From: (wrong string) ಶಿವಸ್ವಾಮಿ <>
Date: Sat, 5 Sep 2009 07:37:57 -0400
Message-ID: <>


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.

PS: I'm on 10GR1.

Received on Sat Sep 05 2009 - 06:37:57 CDT

Original text of this message