Hello All, We are seeing below error for one of our procedure execution and
later the rerun completing successfully. It happened many times. The error
says one of the parallel slave getting terminated but doesn't say anything
about what exact Ora- error caused the parallel slave to terminate.
We were thinking if we will get the parallel slave failure details
automatically logged in the trace, but we didn't see anything in the trace
file either when searched with *12801*. Any way to find the exact cause of
this failure here?
ORA-20001: ORA-12801: error signaled in parallel query server P005,
instance db01.App1.com:App1u Error Code: -12801
ORA-06512: at "APP_USER.APP1_SP", line 881
ORA-06512: at line 2
The line-881 in the procedure is pointing to inside 'raise application
error', so it doesn't state the exact statement which failed, but anyway
even if we will get the statement we need to understand what exact error is
causing the parallel slave to get terminated.
