Script: Monitor the UNDO progress

From Ittichai Chammavanijakul's Wiki
Revision as of 18:44, 7 October 2011 by Ittichai (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
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/