Not entirely sure, but I think this is a query slave
trying to make, or break a link from another layer
in the DFO.
As the query gets to completion, I would expect
to see the QC gathering results, and the slaves
either in:
PX Deq Send Blkd (i.e. more data to send
but another slave is currently passing data
to the QC)
or
PX Deq Execution message (roughly, this is
from memory) which means all its data has
been transmitted and it is waiting for a message
from the QC to tell it to die.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
-----Original Message-----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 10 April 2002 18:05
All
What does this wait event mean? I have a process that connects to the
database through ODBC and this process is waiting on this event and
SQL*Net message from client.
Often this process waits for an unreasonable amout of time (40000
seconds or more) on SQL*Net MEssage from client and PX Deq: Table Q
qref before it successfully completes...
TIA
Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
