SQL*Net message to client

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Wed, 23 Nov 2005 09:32:28 -0500
Message-ID: <20051123143228.GA13792@cns.vt.edu>

What does WAIT_TIME = -1 indicate?

I have this wait state that I want to learn more about.

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" http://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.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 23 2005 - 08:34:48 CST