Using oradebug one can analyze if an instance is hung $ sqlplus "/as sysdba" SQL> oradebug mysetpid Statement processed. -- no limit on trace file SQL> oradebug unlimit Statement processed. SQL> oradebug hanganalyze 3 Hang Analysis in /u01/oradata/admin/TEST/udump/test_ora_11852.trc -- Wait for couple of minutes SQL> oradebug hanganalyze 3 Hang Analysis in /u01/oradata/admin/TEST/udump/test_ora_11852.trc -- Wait for … Continue reading How to generate systemdump when the instance is hung? →