Check the transaction running in oracle

yuanqc發表於2013-07-14
Oracle
 
SQL> conn scott/tigger
Connected.
SQL>
SQL>
SQL> select distinct sid from v$mystat;
       SID
----------
        28
SQL> create table t( a varchar(3), b varchar(2));
Table created.
SQL> insert into t values('aaa','bb');
1 row created.
SQL>
conn / as sysdba
 
SQL> select SQL_ID from v$session s,v$transaction t where s.TADDR=t.ADDR;
SQL_ID
-------------
g23fmpu17zwku
 
SQL> select SQL_TEXT from v$sqlarea where SQL_ID='g23fmpu17zwku';
SQL_TEXT
--------------------------------------------------------------------------------
insert into t values('aaa','bb')

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10973950/viewspace-766227/，如需轉載，請註明出處，否則將追究法律責任。

相關文章