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.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23825935/viewspace-2933134/ ，如需转载，请注明出处，否则将追究法律责任。
