How to hanganalyze and systemstate dumps for Oracle database？
Oracle support request hang analysis and system state dumps when rasing SR. One 10.1 or higher versions login as sqlplus -prelim / as sysdba To do a hanganalyze oradebug setmypid; oradebug unlimit; oradebug hanganalyze 3; Wait 60 – 90 seconds and run the last command again to identify the process state changes. To get a … Read more