Difference between revisions of "Script: Monitor the UNDO progress"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<pre> | <pre> | ||
| − | select ses.username | + | select ses.username, |
substr(ses.program, 1, 19) command, | substr(ses.program, 1, 19) command, | ||
tra.used_ublk | tra.used_ublk | ||
Latest revision as of 18:44, 7 October 2011
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/
