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: "SQL*Net message to client" Wait event with no SQL*Net connection

Re: "SQL*Net message to client" Wait event with no SQL*Net connection

From: Suzy Vordos <lvordos_at_qwest.com>
Date: Mon, 10 Mar 2003 10:29:11 -0800
Message-ID: <F001.00564D79.20030310102911@fatcity.com>

Are you certain the connection isn't going thru the listener? Check tnsnames.ora and verify that PROTOCOL=BEQ.

JayMiller_at_TDWaterhouse.com wrote:
>
> A developer/analyst was running 4 reports on our datawarehouse, connecting
> locally using SQL Plus from a telnet session on the Unix box. He then
> started 4 queries, spooling the output to the unix server (again, local).
>
> He was curious as to why the sessions were both taking so long and why they
> alternated between showing as Active and Inactive in v$session.
>
> When I checked v$session_wait for his sessions I saw that they were a mix of
> SQL*Net message from client
> and
> SQL*Net message to client
>
> Since he's not connecting through the listener, why would this wait event
> show up? There should be no network activity at all (I double checked that
> the SQL is not using any database links). Any ideas?
>
> Oracle 8.1.6.2
> Solaris 2.6
>
> Thanks,
> Jay Miller
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: JayMiller_at_TDWaterhouse.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Mar 10 2003 - 12:29:11 CST

Original text of this message

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