查询某个会话正在执行的事务
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/,如需转载,请注明出处,否则将追究法律责任。