System state dump and Hanganalyze

1. System state dump

sqlplus / as sysdba

SQL> oradebug setmypid

SQL> oradebug unlimit

SQL> oradebug tracefile_name

SQL> oradebug -g all dump systemstate 267



SQL> oradebug -g all dump systemstate 267



SQL> oradebug -g all dump systemstate 267

SQL> exit

2.Hanganalyze


sqlplus / as sysdba

SQL> oradebug setmypid

SQL> oradebug setinst all

SQL> oradebug unlimit

SQL> oradebug tracefile_name

SQL> oradebug -g def hanganalyze 3



SQL> oradebug -g def hanganalyze 3



SQL> oradebug -g def hanganalyze 3

SQL> exit