Difference between revisions of "Script: Monitor the UNDO progress"
Jump to navigation
Jump to search
(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://...") |
|||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<pre> | <pre> | ||
− | select ses.username | + | 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; | where ses.saddr = tra.ses_addr; | ||
</pre> | </pre> |
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/