RE: Parallel Query Server died

[Govind.Arumugam]

Shuan,

 

Please let me know whether you are on 9i.  When was the database bounced cleanly?  After shutting down the oracle instance,

check to make sure that no other orphaned background processes are present.

 

ie. ps -ef | grep -i oracle should return nothing.

 

We got burnt by this ORA-12805 several weeks back.  We did bounce the database cleanly while implementing one of our application patches and the no. of ORA-12805 occurrences have come down dramatically.  

 

Also, the query plans have changed in 9i.  If you see more full table scans in 9i than in 8i versions, try to compare the query plans with these session level settings.

 

CBO Hidden parameter to generate 8.1.7 like query plans:

 

alter session set "_UNNEST_SUBQUERY" = FALSE;
alter session set "_ORDERED_NESTED_LOOP" = FALSE;
alter session set "_ALWAYS_SEMI_JOIN" = off;

explain plan for

<your parallel query>;

 

HTH.

 

Govind

-----Original Message-----
From: Mogens N?rgaard [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 31, 2003 10:48 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Parallel Query Server died

This server is dead. It has gone to meet its maker. It is no more. It's pushing up the lillies....... This... is an ex-server.

Thanks to Monty Python.

Jamadagni, Rajendra wrote:

Funeral at 8pm EST, movie at 11pm EST on TNT ...

 

Raj

-----Original Message-----
From: Rajesh Dayal [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 31, 2003 2:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Parallel Query Server died

After long time ..

 

LOL .........  ;-)

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vladimir Barac
Sent: Friday, May 30, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Parallel Query Server died

Kool, now some cyber funeral will take place...

----- Original Message -----

From: shuan.tay(PCI嚙瘦嚙磋嚙踝蕭)

To: Multiple recipients of list ORACLE-L

Sent: Friday, May 30, 2003 11:19

Subject: Parallel Query Server died

Dear all DBAs,

 

What should i check for this error?

"ORA-12805: parallel query server died unexpectedly"

 

The SQL statement was running well before.

There's nothing in the alert log about this error.

 

I'm using Oracle 8.1.6 on Redhat 7.2.

 

Thanks and have a nice day.

*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1