Issue:
Oracle DB: 12.1.0.2
While running one select query it was failing with below exception.
ORA-10173: Dynamic Sampling time-out error
ORA-07445: exception encountered: core dump [qcdlgcd()+70] [SIGSEGV] [ADDR:0x4] [PC:0xCDFB0E6] [Address not mapped to object] []
Troubleshoot:
Seeing the ORA-10173, I initially thought it might be the issue with dynamic sampling triggered by sql plan directive, I have gathered stats on the table which didn’t work.
Later disabled dynamic sampling at the session level to verify , query again failed with ORA-07445
Resolution:
Later came across oracle MOS note 2028777.1 mentioning to set the hidden parameter to false.
alter session set “_index_join_enabled”=false;
My symptoms for the issue are same after enabling the 10053 trace and checking the _index_join_enabled parameter.
References:
ORA-07445: core dump [qcdlgcd()+70] for Union All Statement : No More Data To Read From Socket (Doc ID 2028777.1)
ORA-10173: Dynamic Sampling time-out error in alert.log (Doc ID 1491818.1)