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
__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the
convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/
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: [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).
