查询某个会话正在执行的事务
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)
|
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/40239/viewspace-705244/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/40239/viewspace-705244/