The production database hang, try to get the systemstat
++++++++++++++++++
%oracle_home%\bin\sqlplus -prelim / as sysdba
oradebug setmypid
oradebug unlimit;
oradebug dump systemstate 266
oradebug dump systemstate 266
++++++++++++++++++
Then, it got a error in alert log
++++++++++++++++++
System State dumped to trace file
Tue May 19 13:16:12 2009
Errors in file d:\oracle\product\10.2.0\admin\fspdc\udump\fspdc_ora_12612.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kgxAolDump+208] [PC:0x50C15B6] [ADDR:0x88] [UNABLE_TO_READ] []
++++++++++++++++++
It caused by a bug.
The solution from metalink
Cause
Issue was filed as and was closed as a duplicate of unpublished bug 5730231.
Solution
The issue is not resolved in any known patches. The below workaround was provided:
Workaround
~~~~~~~~~~~~
Connect / as sysdba (without -prelim)
-OR-
Force the variable PGA to be initialized
eg:
sqlplus -prelim '/ as sysdba'
oradebug setmypid
oradebug unlimit;
oradebug call ksmcpg
oradebug dump systemstate 10
阅读(847) | 评论(0) | 转发(0) |