1 Reply Latest reply on Feb 19, 2008 6:43 AM by Hussein Sawwan-Oracle

    SQL*Net message from client

      I'm working on release12. and When i query select * from v$session_wait. Mostly is returning this below event
      "SQL*Net message from client". So can anyone tell about this?will it affect the performance?

        • 1. Re: SQL*Net message from client
          Hussein Sawwan-Oracle
          The event "SQL*Net message from client" means that the server is waiting for a new command/message from the client process.

          One use of this event is to determine how long each connection has been idle by running the following query:
          SQL> select sid, seconds_in_wait
          from v$session_wait 
          where state='WAITING' and event='SQL*Net message from client'
          order by seconds_in_wait desc;
          Note: 34395.1 - WAITEVENT: "SQL*Net message from client" Reference Note