RE: Parallel Query Server died

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-----

Sent: Saturday, May 31, 2003 10:48 PM
To: Multiple recipients of list ORACLE-L

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-----

Sent: Saturday, May 31, 2003 2:50 AM
To: Multiple recipients of list ORACLE-L

After long time ..  

LOL ......... ;-)
-----Original Message-----

Barac
Sent: Friday, May 30, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L

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

• Original Message ----- To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com> Sent: Friday, May 30, 2003 11:19

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

  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <Govind.Arumugam_at_alltel.com
  INET: Govind.Arumugam_at_alltel.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).