Thats what I thought. But here is more details on the issue..

I am running a SQL*PLus session with a massive query that returns about 2.5g of data, i am spooling the data to file - that is something similar to what the essbase application is trying to do.

that session spooled the data in around 2 hours - so the access paths are fine. after getting the data though, my sql session has still not completed. from the size of the spool file i can see the data came more then three hours ago. this session is still doing something and these waits are increasnig and sql is not returning the SQL prompt to me...

trying to find out why...


Original Message -----
From: Deshpande, Kirti
To: ORACLE-L_at_fatcity.com; orclbabu_at_hotmail.com
Sent: Wednesday, April 10, 2002 2:52 PM
Subject: RE: PX Deq: Table Q qref

Looks like you have PQ enabled.
These waits are considered idle.
The PQ slave processes are waiting for work to do.

-----Original Message-----
From: Babu Nagarajan
Sent: Wednesday, April 10, 2002 12:51 PM
To: Multiple recipients of list ORACLE-L
Subject: PX Deq: Table Q qref


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...



Please see the official ORACLE-L FAQ: http://www.orafaq.com
Author: Babu Nagarajan
INET: orclbabu_at_hotmail.com

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: ListGuru_at_fatcity.com (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).

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 8 | next ›
Discussion Overview
grouporacle-l @
postedApr 10, '02 at 5:51p
activeApr 12, '02 at 9:09a



site design / logo © 2022 Grokbase