Search notes:
oradebug hanganalyze
$ sqlplus / as sysdba
…
oradebug setmypid
oradebug unlimit
oradebug hanganalyze
… [ wait a minute or so, see MOS Note 4523581.1 ]
oradebug hanganalyze
oradebug tracefile_name
…
exit
10g and above (MOS Note 4523581.1)
oradebug setmypid
oradebug unlimit
oradebug -g all hanganalyze 3
oradebug -g all hanganalyze 3
oradebug -g all dump systemstate 258
oradebug -g all dump systemstate 258
Hanganalyze levels
3 | In 11g onwards, level 3 also collects a short stack for relevant processes in hang chain |
4 | Collects everything from level 3 and dumps leaf nodes (blockers) in wait chains |
5 | Collects everything from level 4 and dumps all processes involved in wait chains |