Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: PS Enqueue

Re: PS Enqueue

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Thu, 16 Nov 2006 14:16:58 -0800 (PST)
Message-ID: <20061116221658.4134.qmail@web31905.mail.mud.yahoo.com>


Hi,    

  From your mail it is not clear if you have found out who is the holder of the PS enqueue.   Since you have a systemstate dump you might want to log a Tar with OSS and confirm if you are hittig   bug 3840866
  PARALLEL QUERY ENQUEUE IS NOT RELEASED   or any of its variants    

  Thanks
  -Fairlie   

LS Cheng <exriscer_at_gmail.com> wrote:

    Hi    

  My users have a parallel query running since 3 days ago, the query in fact isnt that slow, the processes seems finished but are waiting for PS enqueue (Parallel Slave Sincronization). I tusc the processes and they all showing "sleepping" status, I ran a systemstate dump and process state dump and they all show the PQ coordinator and Slaves are waiting for PS enqueue.    

  v$session_Wait shows coordinator waits for SQL*Net messages from client and the slaves parallel execution dequeue wait and some send blk messages.    

  I was wondering who the heck are they waiting for?    

  Running Oracle 9.2.0.4 on HP-UX 11.11 (not my fault not running 9.2.0.8 at this time of the year.....)    

  Thanks    

  --
  LSC               Fairlie Rego
Senior Oracle Consultant
  http://www.linkedin.com/in/fairlierego   

  http://el-caro.blogspot.com/
  M: +61 402 792 405      



Sponsored Link

   Mortgage rates as low as 4.625% - $150,000 loan for $579 a month. Intro-*Terms
--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 16 2006 - 16:16:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US