Re: Parallel Query Sync Wait

Can't really give you any better source to v$ views than the reference manual combined with a lot of experiments that are specific to your version of Oracle - (but my experience is for hire, of course ;).

When you look at the other slaves, p2raw will be 1001FFFF (or 1000FFFF perhaps on your version) for slaves expecting a response from the QC.

Check for trace files (in the background dump dest) for a failed slave.

You may find an upgrade to 7.3.3.5 from 7.3.3.4 helps - it certainly fixed a lot of problems I was seeing at one site.

(Did you mean 7.3.4 when you said 7.4 ? I didn't think there was going to be a 7.4 - If it is 7.3.4, then you need 7.3.4.3 as I recall there being a couple of other bugs that weren't fixed until then).

--

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

Ben F Oliver wrote in message <7mp4ms$7pp_at_dfw-ixnews16.ix.netcom.com>...

> Thanks,
>This gives me something to work with. It really bothered me that Precise
was labeling this
>wait as Parallel Query Sync. Wait. The "reason" found in the v$session_wait
makes more
>sense. By the way SID 121 was the QC. When it fails again, I'll look at the
slaves and see
>what they are reporting. I did not check to see if all the slaves were
still executing
>during the lock-up but I have a suspicion that one of the slaves
terminated. Do you know any
>source for detailed information on the v$ view fields?
>
>I will continue to post progress on this thread as I progress. I know that
many others using
>PQO must be having this problem. I will be upgrading to 7.4 soon and am
going to create an
>exact duplicate of my 7.3.3.4 environment and application and see if I have
the same
>problems.
>
>Again, thanks for the help.
>
Received on Sat Jul 17 1999 - 03:39:06 CDT