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:

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