ORACLE HANG ANALYZE

 Below given are the steps to generate Hanganalyze and Systemstate 

Hanganalyze: 

===================== 

sqlplus '/ as sysdba' 

oradebug setmypid; 

oradebug unlimit; 

oradebug hanganalyze 3; 

-- Wait upto 1 minute before getting the second hanganalyze 

oradebug hanganalyze 3; 

-- Wait upto 1 minute before getting the second hanganalyze 

oradebug hanganalyze 3; 

oradebug tracefile_name; 

exit 

Systemstate Dump: 

================ 

sqlplus '/ as sysdba' 

oradebug setmypid; 

oradebug unlimit; 

oradebug dump systemstate 258; 

-- Wait upto 1 minute before getting the second system state 

oradebug dump systemstate 258; 

-- Wait upto 1 minute before getting the second system state 

oradebug dump systemstate 258; 

oradebug tracefile_name; 

exit