Home » SQL & PL/SQL » SQL & PL/SQL » ORA-12805: parallel query server died unexpectedly (Win XP, Oracle 10g)
ORA-12805: parallel query server died unexpectedly [message #377491] Tue, 23 December 2008 04:17 Go to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
Hi All,

I am getting ORA-12805:, error message for the query I created,
My query is very simple and is using union between 3 queries.Also for 2 of them I have used Parallel hint of degree 2, so is this the reason am I getting ORA-12805...?

Whats the work-around?

thanks ,
Freakabhi
Re: ORA-12805: parallel query server died unexpectedly [message #377508 is a reply to message #377491] Tue, 23 December 2008 05:07 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Hi Freakabhi,

I didn't get your question.
If you will provide enough description of your question, you will get quick reply.

regards,
Delna
Re: ORA-12805: parallel query server died unexpectedly [message #377539 is a reply to message #377491] Tue, 23 December 2008 06:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12805: parallel query server died unexpectedly
 *Cause: A parallel query server died unexpectedly, PMON cleaning
         up the process.
 *Action: Check your system for anomalies and reissue the statement.
          If this error persists, contact Oracle Support Services.
          See trace file for more details.

Regards
Michel
Re: ORA-12805: parallel query server died unexpectedly [message #377617 is a reply to message #377491] Tue, 23 December 2008 23:33 Go to previous messageGo to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
My Query is of following type:

Select /*+ parallel(C,2) */
* from claim_a C

union

Select /*+ parallel(r,2) */
* from claim_b r

union

Select
* from claim_C d

Whenever I run the query, It runs for while (around 10-15 mins)
and then gives "ORA-12805 : parallel query server died unexpectedly"

Is it because of the Database setting or what, or due to Parallel hints


from,
freakabhi

[Updated on: Tue, 23 December 2008 23:34]

Report message to a moderator

Re: ORA-12805: parallel query server died unexpectedly [message #377638 is a reply to message #377617] Wed, 24 December 2008 00:55 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See Action part of my previous message.

Regards
Michel
Previous Topic: Help with PLSQL code for searching
Next Topic: Export Table Data into Excel sheet
Goto Forum:
  


Current Time: Wed Dec 07 09:08:36 CST 2016

Total time taken to generate the page: 0.08814 seconds