RAC - Instance hang issue - global hanganalyze and systemstate dump
sqplus / as sysdba or sqlplus -prelim / as sysdba
1. Please run the following on one instance as sysdba:
SQL>oradebug setmypid
SQL>oradebug unlimit
SQL>oradebug -g all hanganalyze 10
Wait for 30 seconds
SQL>oradebug -g all hanganalyze 10
SQL>oradebug tracefile_name
SQL>exit
2. Open another session as sysdba:
SQL>oradebug setmypid
SQL>oradebug unlimit
SQL>oradebug -g all dump systemstate 258
Wait for 30 seconds
SQL>oradebug -g all dump systemstate 258
SQL>oradebug tracefile_name
SQL>exit
