RE: ``SQL*Net message to client`` Wait event with no SQL*Net

I think the point that was missed here is that there are two types of SQL*Net connections possible. These are connections made through local or remote protocols. For local protocols, connections can be made with the "bequeath" adapter which does not require a listener connection, or an IPC adapter which will use a listener connection. For remote protocols, typically TCP is used and are always through a listener connection.

At 01:19 PM 3/10/2003 -0800, you wrote:
>I'm not sure we're hitting the nail on this one. Just a sqlplus
>user/password locally should not use the listener because it works when
>the listener is stopped.
>
><<< JayMiller_at_TDWaterhouse.com 3/10 1:31p >>>
>Thanks Lisa, but I already checked that.
>
>I used to think this as well. But according to Rachel and Tom the listener
>is apparently used even if the @sid is not present.
>
>Glad I wasn't the only one laboring under that misapprehension :)
>
>Jay

Andy Rivenes
arivenes_at_llnl.gov

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Andy Rivenes
  INET: arivenes_at_llnl.gov

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).