Tuesday, 5 March 2013

ORA-07445: exception encountered: core dump [kqrpre1()+2780]


ORA-10387: parallel query server interrupt (normal)
ORA-07445: exception encountered: core dump [kqrpre1()+2780]

ORA-07445: exception encountered: core dump [kghadjust()+120]

Stack trace for the error ORA-07445 [kghadjust()+120] is similar to:
kghadjust kghupr_flg kghupr kglophup kglHandleUnpin




Cause:--
This is unpublished Bug:4927533 - INSTANCE CRASHED WITH ORA-7445 [KGHADJUST],

Solution:--
Fix:
Unpublished Bug:4927533 is fixed in 10.2.0.3 and in 11g.

One-off patches may be available depending on your current release and operating system.
To obtain a patch from MetaLink:
1) Click on 'Patches and Updates'
2) Click on 'Simple Search'
3) Enter patch number: 4927533
4) Select your O/S
5) Click Go.

Workaround:--
set _bloom_filter_enabled=FALSE.

Setting the parameter _bloom_filter_enabled=FALSE may have a preformance impact,
re-gather statistics on the object to resolve the performance issue.

ORA-00600: internal error code, arguments: [17147]
------------------------------------------------------------------------------------------------------------

 BUG:5469910 - Abstract: INSTANCE CRASHED WITH ORA-7445 [KGHADJUST]

 

No comments:

Post a comment