Ora-00600[KGHLKREM1](三)

2014-11-24 17:05:57 · 作者: · 浏览: 3
547e90 siz=10056 efr 110547dc0 siz=10032
Cursor frame dump
enxt: 5.0x00000010
pnxt: 2.0x00000008 pnxt: 1.0x00000010
kxscphp 1106b4dc8 siz=6552 inu=6000 nps=5856
kxscdfhp 1105b5be0 siz=984 inu=88 nps=0

分析:
符合Oracle的一个已知的BUG:
Bug 6137313 : SMON CRASHED WITH ORA-600 [KGHLKREMF()+33] AFTER ORA-600 [KGHLKREM1]
BUG:5736850 MULTI KILL SESSION LEADS TO SGA CORRUPTION

Oracle提供的解决方法:
1. Upgrade to a supported release, 11.2.0.3
or
2. Apply the 10.2.0.5.0 patchset
or
3. Use the known workaround of setting:
SQL> alter system set "_bloom_filter_enabled"=false scope=both;