Skip to Main Content
  • Questions
  • parallel thread dies unexpectedly ORA-12805

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, manisha.

Asked: April 28, 2022 - 4:49 am UTC

Last updated: May 03, 2022 - 3:54 am UTC

Version: 19c

Viewed 1000+ times

You Asked

sql having parallel hint with degree 4 is running fine on prod enviornment but on lower enviornment it is prompting
error code [12805]; ORA-12805: parallel query server died unexpectedly.Could you pls help what could be the possible cause?

and Connor said...

Check your alert log - often it will reference an incident or trace file which contains more details.

Also check out MOS note 1348002.1 which talks about troubleshooting methods, including how to get a full error stack which can be provided to support.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.