Home » SQL & PL/SQL » SQL & PL/SQL » Parallel Query Died
Parallel Query Died [message #217576] Fri, 02 February 2007 18:52 Go to next message
Messages: 21
Registered: November 2006
Location: HYD
Junior Member

I am using a sub-query for inserting data into a tempopary table. The sub-query is executing in 430msec. But when i am trying to insert that data into table then i am getting
this error

"ORA-12805: parallel query server died unexpectedly"

I am using Oracle 10g
Please help me out to resolve this error

Re: Parallel Query Died [message #217577 is a reply to message #217576] Fri, 02 February 2007 18:55 Go to previous message
Messages: 25537
Registered: January 2009
Location: SoCal
Senior Member
12805, 00000, "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.

When a ORA-12805 occurs in most cases you will also see another error, ORA-600 or a ORA-7445.

Metalink has at least 1 known bug logged against this error code.

[Updated on: Fri, 02 February 2007 19:02] by Moderator

Report message to a moderator

Previous Topic: Identifier too long error
Next Topic: Seelct records with recent Update_Date
Goto Forum:

Current Time: Wed Jul 26 03:53:17 CDT 2017

Total time taken to generate the page: 0.14461 seconds