hanganalyze快速收集步骤

2020 年 3 月 12 日 星期四

下午 5:06

ACTION PLAN 

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

1. Please run the following on one instance as sysdba: 

SQL>oradebug setmypid 

SQL>oradebug unlimit 

SQL>oradebug -g all hanganalyze 3 

Wait for 30 seconds 

SQL>oradebug -g all hanganalyze 3 

SQL>exit 

2. Open another session as sysdba: 

SQL>oradebug setmypid 

SQL>oradebug unlimit 

SQL>oradebug -g all dump systemstate 258 

Wait for 30 seconds 

SQL>oradebug -g all dump systemstate 258 

SQL>oradebug tracefile_name 

SQL>exit 

3. The generated trace files will be in the diag trace file in BDUMP for each instance, please upload these files.