Script: Monitor the UNDO progress
Revision as of 16:03, 7 October 2011 by Ittichai (talk | contribs) (moved Sscript: Monitor the UNDO progress to Script: Monitor the UNDO progress)
select ses.username , substr(ses.program, 1, 19) command , tra.used_ublk , from v$session ses , v$transaction tra where ses.saddr = tra.ses_addr;
Reference: http://gavinsoorma.com/2009/06/how-to-monitor-the-progress-of-an-undo-operation/