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: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to