Tuesday, December 26, 2023

Deadlock is not reflecting alert log

                                                                     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'








No comments:

Post a Comment