Deadlock tracing in oracle
A deadlock is event 60:
SQL> alter session set events '60 trace name hanganalyze level 4';
For RAC, you may want systemstate=266:
SQL> alter session set events '60 trace name hanganalyze_global ; name systemstate level 266'
SQL> alter session set events '60 trace name hanganalyze level 4';
For RAC, you may want systemstate=266:
SQL> alter session set events '60 trace name hanganalyze_global ; name systemstate level 266'
No comments:
Post a Comment