Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Question on SQL*Net message from client

Re: Question on SQL*Net message from client

From: Neil Overend <neiloverend_at_gmail.com>
Date: Thu, 10 May 2007 08:23:56 +0100
Message-ID: <5acbeade0705100023k39ed9a97rb290d2180808ac6@mail.gmail.com>


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
Received on Thu May 10 2007 - 02:23:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US