SQL*Net message to client
- From: Ray Stell <stellr@xxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Nov 2005 09:32:28 -0500
What does WAIT_TIME = -1 indicate?
I have this wait state that I want to learn more
about.
EVENT
---------------------------------------
SQL*Net message to client
P1TEXT P1 P1RAW
---------- ---------- ----------------
driver id 1650815232 0000000062657100
P2TEXT P2 P2RAW
---------- ---------- ----------------
#bytes 1 0000000000000001
P3TEXT P3 P3RAW
---------- ---------- ----------------
0 00
WAIT_TIME SECONDS_IN_WAIT STATE
--------- --------------- -------------------
-1 0 WAITED KNOWN TIME
Jonathan Lewis wrote this on the "WAITED KNOWN TIME"
//www.freelists.org/archives/oracle-l/03-2004/msg03181.html
which indicates this is a cpu use indicator.
WAIT_TIME - NUMBER
A nonzero value is the session's last wait time. A zero value means the session
is currently waiting.
Thanks.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
