Simple query crushed with ORA-07445: exception encountered: core dump [kkqjpdGetSavedColStatsCB()+93] [SIGSEGV] [Address not mapped to object] [0xC] [] []

Hi All


Here the new issue that I found after upgrade to 10.2.0.5.
When I run the simple sql query, I'm got the following error:

There is following error in alert log file:
ORA-07445: exception encountered: core dump [kkqjpdGetSavedColStatsCB()+93] [SIGSEGV] [Address not mapped to object] [0xC] [] [].


In trace file:
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kkqjpdGetSavedColStatsCB()+93] [SIGSEGV] [Address not mapped to object] [0xC] [] []

The issue seems related to the BUG 12800599 which is still under processing .
Workaround: "_optimizer_push_pred_cost_based"=false



The best option is to use the hint at sql level so it won't affect other sqls transformation .
If the parameter is set at system level (init.ora), need to test the effect of performance of other sql's. As it switches off cost based predicate pushing option , it can affect small number of queries if at all they go for this transformation. It may also not affect on application at all. 
So, a test needs to be done if the parameter is set at system level.


Good luck ...