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]
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;