How to resolve ORA-03114 ; ORA-03113 : end-of-file on communication channel?

We have got a merge query and found out that its failing on ORA-03114 ; ORA-03113 : end-of-file on communication channel?

After doing some research and testing we found setting a hidden parameter value to false would prevent this from happening.  We did manager to fix this error. These are dynamic parameters, that means we can change them without a need of the instance to go through rolling restart.

In my case these parameters were enabled and set to true. As soon as we changed them to false the merge statement was able to finish successfully.

set line 100
col Parameter for a50
col "Session Value" for a20
col "Instance Value" for a20
SELECT a.ksppinm "Parameter",b.ksppstvl "Session Value",c.ksppstvl "Instance Value" FROM x$ksppi a, x$ksppcv b, x$ksppsv c WHERE a.indx = b.indx AND a.indx = c.indx AND a.ksppinm in ( '_optimizer_use_cbqt_star_transformation', '_replace_virtual_columns');

_optimizer_use_cbqt_star_transformation and _replace_virtual_columns

ACTION PLAN:
alter session set "_optimizer_use_cbqt_star_transformation" = false;

alter session set "_replace_virtual_columns"=false;

Hope this helps!

Ahmad