(1) Execute the following steps to take a hang analyze dump and a system state dump:
(a) Non-RAC
$ sqlplus '/ as sysdba'
oradebug setmypid
oradebug unlimit
oradebug hanganalyze 3
quit
(b) RAC
$ sqlplus '/ as sysdba'
oradebug setmypid
oradebug unlimit
oradebug setinst all
oradebug -g all hanganalyze 3
quit
(2) Wait at least 1 minute and then repeat step 1 to take a second set of dumps.
(3) Zip the newly created trace files including the process state dumps listed in the hang analyze trace file and upload the resulting zip file.
If you are unable to connect to the database you can instead connect to another process to collect the system state dumps as described in Note 121779.1.
No comments:
Post a Comment