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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
