System Dump and Hang Analyze
- mdvorkin
- Nov 19, 2020
- 1 min read
Updated: Mar 16, 2021
System Dump (should be done 3 times with intervals of at least 1 min):
sqlplus "/ as sysdba"
oradebug setmypid
oradebug unlimit
oradebug dump systemstate 10
oradebug tracefile_name
exit;
Hanganalyze:
sqlplus "/ as sysdba"
oradebug setmypid
oradebug unlimit
oradebug hanganalyze 3
exit;
Comments