Script: Monitor the UNDO progress

From Ittichai Chammavanijakul's Wiki

Revision as of 16:02, 7 October 2011 by Ittichai (talk | contribs) (Created page with "<pre> 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; </pre> Reference: http://...")

(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/

Retrieved from "https://ittichaicham.com/wiki/index.php?title=Script:_Monitor_the_UNDO_progress&oldid=544"

Oracle Scripts