Script: Monitor the UNDO progress - Revision history

Ittichai at 23:44, 7 October 2011

2011-10-07T23:44:36Z

Ittichai at 21:07, 7 October 2011

2011-10-07T21:07:41Z

Ittichai: moved Sscript: Monitor the UNDO progress to Script: Monitor the UNDO progress

2011-10-07T21:03:44Z

moved Sscript: Monitor the UNDO progress to Script: Monitor the UNDO progress

Ittichai: Created page with "

 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://..."

2011-10-07T21:02:59Z

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://..."

New page

<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://gavinsoorma.com/2009/06/how-to-monitor-the-progress-of-an-undo-operation/

[[Category: Oracle Scripts]]

@@ Line 1: / Line 1: @@
 <pre>
-select ses.username.
+select ses.username,
    substr(ses.program, 1, 19) command,
    tra.used_ublk

← Older revision	Revision as of 21:03, 7 October 2011
(No difference)