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
ananth.dikshit
Messages: 21
Registered: November 2006
Location: HYD
Junior Member
Hi,

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


Thanks
Ananth
Re: Parallel Query Died [message #217577 is a reply to message #217576] Fri, 02 February 2007 18:55 Go to previous message
BlackSwan
Messages: 25035
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: Sat Dec 03 16:04:12 CST 2016

Total time taken to generate the page: 0.10076 seconds