TAGS
Session altered.
In the example above I tell Oracle to invoke a RAC global hang analyze and a systemstate dump with short stacks of processes ( level 256 10 = 266 ) whenever an ORA-60 deadlock error is raised.
It is possible to specify different options such level, event lifetime etc at each action level, for example we might not want to dump systemstate multiple times if the deadlock keeps reoccurring:
SQL> alter session set events '60 trace name hanganalyze_global level 4, forever; -
Previous Next
.
