Re: Parallel Query Sync Wait

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 9 Jul 1999 09:06:24 +0100
Message-ID: <931507854.25665.0.nnrp-01.9e984b29@news.demon.co.uk>

What tool do you use, and which version of Oracle.

'Parallel Query Sync Wait' does not exist as a wait event in 7.3.3, 8.0.4, or 8.1.5

When it stick again, identify the SID, then do:

set linesize 2000
set trimspool on
spool {spool file}
select * from v$session_wait where sid = {whatever it was};

repeat the select every few seconds to get 5 consecutive results spool off
and post the results

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Ben F Oliver wrote in message <7m3v4m$2i8_at_dfw-ixnews15.ix.netcom.com>...
>I am running PQ Option on a multi-processor HP-UX system. Occasionally, one
batch process
>locks up. When investigated, the tool I use shows Parallel Query Sync Wait.
I cannot find any
>info on Metalink and forget about asking Oracle Support.
Received on Fri Jul 09 1999 - 03:06:24 CDT