this wait means.
|
|5.After two hours, it starts waiting on PX Deq: Table Q qref and
SQL*Net
|message to client. By this time, it has finished writing to the
spool file.
|I verified this from the unix timestamp. The trace also shows FETCH
|#1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=57419669
|
|6
on what this wait means.
5.After two hours, it starts waiting on PX Deq: Table Q qref and SQL*Net
message to client. By this time, it has finished writing to the spool file.
I verified this from the unix timestamp. The trace also shows FETCH
#1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim
and PX Deq: Table Q qref before it successfully completes...
TIA
Babu
-LSubject: PX
Deq: Table Q qref
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 (4 seconds
the SQL
prompt to me...
trying to find out
why...
babu
- Original Message -
From:
Deshpande, Kirti
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 2:52
PM
Subject: RE: PX Deq: Table Q qref
Looks like you have PQ enabled.
These waits
Babu - Are you running this session in the background? On my system (Compaq
Tru64), when I run a SQL*Plus script in the background, I have to put the
EXIT command as the last command of the script. Otherwise the script just
sits there and echos the prompt into the spool file until it fills up the
No. i am running it from the foreground...
babu
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 5:48 PM
Babu - Are you running this session in the background? On my system
(Compaq
Tru64), when I run a SQL*Plus script in