SQL，查询正在执行的事务
SQL：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
set linesize 600 col event for a18 col sql_text for a29 col sql_fulltext for a29 col username for a9 col machine for a9 col program for a18 col direct_writes for a18 col terminal for a9 SELECT s.sid, s.serial#, s.event, a.sql_text, a.sql_fulltext, s.username, s.status, s.machine, s.terminal, s.program, a.executions, s.sql_id, p.spid, a.direct_writes FROM (SELECT * FROM v$session WHERE status = 'ACTIVE') s LEFT JOIN v$sqlarea a ON s.sql_id = a.sql_id INNER JOIN v$process p ON s.paddr = p.addr where sql_text is not null and rownum<2; |
Like This：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 |
SQL> set linesize 600 SQL> col event for a18 SQL> col sql_text for a29 SQL> col sql_fulltext for a29 col username for a9 SQL> SQL> col machine for a9 SQL> col program for a18 SQL> col direct_writes for a18 col terminal for a9 SQL> SQL> SELECT s.sid, s.serial#, 2 3 s.event, 4 a.sql_text, 5 a.sql_fulltext, 6 s.username, 7 s.status, 8 s.machine, 9 s.terminal, 10 s.program, 11 a.executions, 12 s.sql_id, 13 p.spid, 14 a.direct_writes 15 FROM (SELECT * FROM v$session WHERE status = 'ACTIVE') s 16 LEFT JOIN v$sqlarea a 17 ON s.sql_id = a.sql_id 18 INNER JOIN v$process p 19 ON s.paddr = p.addr 20 where sql_text is not null and rownum<2; SID SERIAL# EVENT SQL_TEXT SQL_FULLTEXT USERNAME STATUS MACHINE TERMINAL PROGRAM EXECUTIONS SQL_ID SPID DIRECT_WRITES ---------- ---------- ------------------ ----------------------------- ----------------------------- --------- -------- --------- --------- ------------------ ---------- ------------- ------------------------ ------------- 7 29 db file sequential DELETE FROM "SXMSPMAST" WHERE DELETE FROM "SXMSPMAST" WHERE SAPSR3 ACTIVE uxgdc115 dw.sapNXP_DVEBMGS0 16 5zs82knjqrj2r 8716586 ########## read "MANDT"=:A0 AND "MSGGUID"=:A "MANDT"=:A0 AND "MSGGUID"=:A 0@uxgdc115 (TNS V1 1 AND "PID"=:A2 1 AND "PID"=:A2 -V3) SQL> |
——————
Done。
