| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Wait Stats Question
Hi,
I have used the following sql query to get wait stats :
Select sid, event, p1, p2, p3, wait_time, Seconds_in_wait, state
from V$session_wait where sid >6 and event not like '%SQL%' and event not like '%rdbms%'
order by 7
/
As a result of this query, I got the wait stats and I have found explanation for all wait events except for the following. Could you please help me understand as to what these events or where can I find the explanations for these events.
SID EVENT P1 P2 P3 WAIT_TIME SECONDS_IN_WAIT STATE ----- ------------------------------ ---------- ---------- ---------- ---------- --------------- ---------- 22 PX Deq: Execution Msg 268566527 6 0 0 34 WAITING 36 PX Deq: Execution Msg 268566527 18 0 0 34 WAITING 63 PX Deq: Execution Msg 268566527 18 0 0 34 WAITING 48 PX Deq Credit: send blkd 268566527 1 0 0 38 WAITING
Thanks for your time.
CP
Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: csp2201_at_netscape.net
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). Received on Tue May 14 2002 - 10:33:20 CDT
 |
 |