Fix-ORA-39014

 

  ORA-39014: One or more workers have prematurely exited.

Solution:

1. If available for your Platform Download Patch 5879865 to resolve this issue. 

2. In the meantime, please use one of the following as a workaround:

* set both of the following in the init/spfile

o "_complex_view_merging" = false
o event="38066 trace name context forever, level 1" or level 2

OR

* set "_optimizer_cost_based_transformation"=off

 

Hope it do wonders !!!!!