查询某个会话正在执行的事务

2011-8-17

SQL:

select  sql.sql_text 
  from v$session s, v$transaction t, v$sql sql
where s.sADDR = t.SES_ADDR and  (s.sql_id = sql.sql_id  or s.PREV_SQL_ID = sql.sql_id)
and s.username='SYS'

例子：

SQL> desc t
ERROR:
ORA-04043: object t does not exist


SQL> create table t (a int);

Table created.

SQL> insert into t values(100);

1 row created.

SQL> select  sql.sql_text 
  2  from v$session s, v$transaction t, v$sql sql
where s.sADDR = t.SES_ADDR and  (s.sql_id = sql.sql_id  or s.PREV_SQL_ID = sql.sql_id)
and s.username='SYS'  3    4  ;

SQL_TEXT
--------------------------------------------------------------------------------
insert into t values(100)