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]