systemstate and hang analyse

1. systemstate


$ sqlplus '/ as sysdba'oradebug setmypidoradebug unlimitoradebug dump systemstate 266wait 90 secondsoradebug dump systemstate 266wait 90 secondsoradebug dump systemstate 266quit
need this doing on all nodes

2. hang analyse in a new session

sqlplus / as sysdba
oradebug setmypidoradebug unlimitoradebug tracefile_nameoradebug -g all hanganalyze 3... wait a minute or two here...oradebug -g all hanganalyze 3... wait a minute or two here...oradebug -g all hanganalyze 3
exit

2. Execute the following command every 90 seconds for 3 times

• oradebug setmypid;


• oradebug unlimit;


• oradebug hanganalyze 3;
  

3. Collect Systemstate dumps running the following script every 90 seconds for 3 times

• oradebug setmypid;


• oradebug unlimit;


• oradebug tracefile_name


• oradebug dump systemstate 266;