Re: Question on SQL*Net message from client

From: "Neil Overend" <neiloverend@xxxxxxxxx>
To: Harvinder.Singh@xxxxxxxxxxxxx
Date: Thu, 10 May 2007 08:23:56 +0100

SQL*Net message from client

"Generally, this means the session is sitting idle"

From the book
Oracle Wait Interface : A Practical Guide to Performance Diagnostics & Tuning
Shee, Deshpande and Gopalakrishnan p65. This is an excellent book by the way

This means that oracle is waiting for the client to issue a command.

Also from above ""the database performance is not degraded by high
wait times for this event"

What query did you run to get "Elapsed times include waiting on
following events:" if you're looking at your sessions stats then
perhaps it was 120 seconds between you logging on and running that
query.

Neil
--
http://www.freelists.org/webpage/oracle-l

References:

Re: Query on all_tables taking long time
From: Nigel Thomas

Question on SQL*Net message from client
From: Harvinder Singh

Re: Question on SQL*Net message from client

Other related posts: