Shulou(Shulou.com)06/01 Report--

Since 11g, the trace format of Oracle has changed a lot compared to 10g. The hanganalyze trace format is no exception.

Take a little test and get to know each other.

In session1:

SYS@tst SQL > select * from v$mystat where rownumupdate scott.syk set loc='BJ' where deptno=10;1 row updated.

In session2:

SYS@tst SQL > select * from v$mystat where rownumupdate scott.syk set loc='BJ' where deptno=10

Then in session3, do hanganalyze

SYS@tst SQL > oradebug setmypidStatement processed.SYS@tst SQL > oradebug hanganalyze 3Hang Analysis in / apps/oracle/diag/rdbms/tst/tst/trace/tst_ora_20554.trcSYS@tst SQL > oradebug hanganalyze 3Hang Analysis in / apps/oracle/diag/rdbms/tst/tst/trace/tst_ora_20554.trcSYS@tst SQL > exit

Then check the tst_ora_20554.trc

Chain 1Ra Murmuri-Oracle session identified by: {instance: 1 (xbtst.xbtst) os id: 20433 process id: 30 Oracle@tstdb-25-220 (TNS V1-V3) session id: 246 session serial #: 7817} is waiting for 'enq: TX-row lock contention' with wait info: {p1:' name | mode'=0x54580006 p2: 'usn

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.