Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h9AI7aY21197 for ; Fri, 10 Oct 2003 13:07:36 -0500 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h9AI7ac21191 for ; Fri, 10 Oct 2003 13:07:36 -0500 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.8/8.12.8) with ESMTP id h9AFNQUx012049 for ; Fri, 10 Oct 2003 08:24:01 -0700 Received: (from root@localhost) by ns3.fatcity.com (8.12.8/8.12.5/Submit) id h9AF0MYn003024 for oracle-l@orafaq.net; Fri, 10 Oct 2003 08:00:23 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D2B65; Fri, 10 Oct 2003 07:59:32 -0800 Message-ID: Date: Fri, 10 Oct 2003 07:59:32 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "M Rafiq" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "M Rafiq" Subject: Re: Some bug in 9.2 Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; format=flowed Content-Transfer-Encoding: 7bit Waleed, If I remember correctly, I have seen this type of message in 7.3.4 database 4 years back. If request for parallel query slave exceeds number of parallel_max_servers parameter. Just check this aspect or reduce parallel degree in your code/hint or table/index degree. Regards Rafiq Reply-To: ORACLE-L@fatcity.com To: Multiple recipients of list ORACLE-L Date: Thu, 09 Oct 2003 18:19:25 -0800 This problem started really to be annoying. Suddenly some PQ processes die and the system is never able to bring them back. If some sql is submitted and was lucky enough to request a group of processes that include one of this dead processes, it ends up running without PQ at all. We have RAC 9.2.0.2 on Solaris 2.8. Here is the trace content: *** SESSION ID:(343.56680) 2003-10-09 21:14:17.807 kxfpg1srv could not start local P008 We get this trace in the udump, and nothing goes to bdump. Did any of you experience this problem? Thanks Waleed _________________________________________________________________ Instant message with integrated webcam using MSN Messenger 6.0. Try it now FREE! http://msnmessenger-download.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: rafiq9857@hotmail.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@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).