Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h51GqKN05531 for ; Sun, 1 Jun 2003 11:52:20 -0500 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h51GqKP05526 for ; Sun, 1 Jun 2003 11:52:20 -0500 Received: from fatcity.com (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id HAA71433; Sun, 1 Jun 2003 07:33:15 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 005A7BC9; Sun, 01 Jun 2003 06:54:39 -0800 Message-ID: Date: Sun, 01 Jun 2003 06:54:39 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Subject: RE: Parallel Query Server died Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C32845.6CECF4C6" ------_=_NextPart_001_01C32845.6CECF4C6 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: quoted-printable Shuan, =20 Please let me know whether you are on 9i. When was the database bounced = cleanly? After shutting down the oracle instance,=20 check to make sure that no other orphaned background processes are = present. =20 ie. ps -ef | grep -i oracle should return nothing. =20 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. =20 =20 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. =20 CBO Hidden parameter to generate 8.1.7 like query plans: =20 alter session set "_UNNEST_SUBQUERY" =3D FALSE; alter session set "_ORDERED_NESTED_LOOP" =3D FALSE; alter session set "_ALWAYS_SEMI_JOIN" =3D off; explain plan for ; =20 HTH. =20 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 ... =20 Raj -----Original Message----- Sent: Saturday, May 31, 2003 2:50 AM To: Multiple recipients of list ORACLE-L After long time .. =20 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 -----=20 To: Multiple recipients of list ORACLE-L =20 Sent: Friday, May 30, 2003 11:19 Dear all DBAs, =20 What should i check for this error? "ORA-12805: parallel query server died unexpectedly" =20 The SQL statement was running well before. There's nothing in the alert log about this error. =20 I'm using Oracle 8.1.6 on Redhat 7.2. =20 Thanks and have a nice day. _____ =20 *********************************************************************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 =20 ------_=_NextPart_001_01C32845.6CECF4C6 Content-Type: text/html; charset="big5" Content-Transfer-Encoding: quoted-printable
Shuan,
 
Please=20 let me know whether you are on 9i.  When was the database bounced=20 cleanly?  After shutting down the oracle instance, =
check=20 to make sure that no other orphaned background processes are=20 present.
 
ie. ps=20 -ef | grep -i oracle should return nothing.
 
We got=20 burnt by this ORA-12805 several weeks back.  We did bounce the = database cleanly while implementing one of our application patches = and the=20 no. of ORA-12805 occurrences have come down=20 dramatically.  
 
Also,=20 the query plans have changed in 9i.  If you see more full = table scans=20 in 9i than in 8i versions, try to compare the query plans with = these=20 session level settings.
 
CBO=20 Hidden parameter to generate 8.1.7 like query plans:
 
alter=20 session set "_UNNEST_SUBQUERY" =3D FALSE;
alter session set=20 "_ORDERED_NESTED_LOOP" =3D FALSE;
alter session set = "_ALWAYS_SEMI_JOIN" =3D=20 off;
explain plan for
<your = parallel query>;
 
HTH.
 
Govind
-----Original Message-----
From: Mogens N?rgaard=20 [mailto:mln@miracleas.dk]
Sent: Saturday, May 31, 2003 10:48 = PM
To: Multiple recipients of list = ORACLE-L
Subject: Re:=20 Parallel Query Server died

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

Thanks to Monty = Python.

Jamadagni,=20 Rajendra wrote:
Funeral at 8pm EST, movie at 11pm EST on TNT=20 ...
 
Raj
-----Original Message-----
From: Rajesh Dayal = [mailto:Rajesh@ohitelecom.com]Sent:=20 Saturday, May 31, 2003 2:50 AM
To: Multiple recipients = of list=20 ORACLE-L
Subject: RE: Parallel Query Server=20 died

After long time ..
 
LOL ......... =20 ;-)

-----Original = Message-----
From: root@fatcity.com [mailto:root@fatcity.com]On = Behalf Of=20 Vladimir Barac
Sent: Friday, May 30, 2003 2:35=20 PM
To: Multiple recipients of list = ORACLE-L
Subject:=20 Re: Parallel Query Server died

Kool, now some cyber = funeral will=20 take place...
-----=20 Original Message ----- From:=20 shuan.tay(PCI=BEG=B8R=B3=D4) = To:=20 Multiple recipients of list = ORACLE-L=20 Sent:=20 Friday, May 30, 2003 11:19 Subject:=20 Parallel Query Server died

Dear all DBAs,
 
What should i = check for this=20 error?
"ORA-12805: = parallel query server died=20 unexpectedly"
 
The SQL = statement was running well=20 before.
There's nothing = in the alert log about this=20 error.
 
I'm using Oracle = 8.1.6 on Redhat=20 7.2.
 
Thanks and have = a nice=20 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

------_=_NextPart_001_01C32845.6CECF4C6-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: