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


Other related posts: