Re: performance question

On Fri, 2 Nov 2001, Seema Singh wrote:

> I saw v$session_wait and found event "SQL*Net message from client"
> is having wait_time=0 and second_in_waits value is high.
> I checked every ratio looks good and users are not having any
> problem.What could be problem?

Lazy users.

This event is just a session waiting for something to do.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.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).