RE: Direct Vs. SQL*net

From: Hillman, Alex <Alex.Hillman_at_usmint.treas.gov>
Date: Wed, 18 Apr 2001 12:51:44 -0700
Message-ID: <F001.002EC24C.20010418121521@fatcity.com>

And for getting machine name one can use sys_context('USERENV', 'HOST').

Alex Hillman

-----Original Message-----
Sent: Wednesday, April 18, 2001 2:22 PM
To: Multiple recipients of list ORACLE-L

Charlie,

    Now that's a good question. The best answer I can come up with is to check
the machine column in V$SESSION. if it matches the server machine name then they should be using the beq protocol, I'd think. Otherwise they must be using
SQL*Net. Wonder if anyone else has a suggestion, Hey Jared, your the guru here
aren't you?? :-)

Dick Goulet

____________________Reply Separator____________________
Author: "Charlie Mengler" <charliem_at_mwh.com>
Date:       4/18/2001 9:50 AM

How can one determine via code (PL/SQL)
whether or not the current session is connected "directly" (via the Bequeath protocol) or via SQL*Net?

The solution needs to work for both V7 & V8.

--

Charlie Mengler               Maintenance Warehouse  
charliem_at_mwh.com              10641 Scripps Summit Ct   
858-831-2229                  San Diego, CA 92131    

The future is here. It is just not evenly distributed.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Charlie Mengler
  INET: charliem_at_mwh.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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

Author:
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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

Author: Hillman, Alex
  INET: Alex.Hillman_at_usmint.treas.gov

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Wed Apr 18 2001 - 14:51:44 CDT