Dick,
Try this:
SQL> l
1 select p.spid OSPROCESS,
2 substr(p.program,1,25) OSPROG,
3 substr(s.osuser,1,12) OSUSER,
4 status,
7 substr(s.machine,1,12) MACHINE,
8 s.terminal
10 from v$session s,
11 v$process p
12 where s.paddr = p.addr
14 and osuser = rholman
13* order by osuser, s.sid
SQL>
RESULTS from internal connection:
$. oraenv
$sqlplus sa
OSPROCESS OSPROG OSUSER STATUS MACHINE TERMINAL
--------- ----------------------- ------------ -------- ------- ----------
22446 oracle@cass (TNS V1-V3) rholman ACTIVE cass pts/8
1 row selected.
RESULTS from net8 connection:
$. oraenv
$sqlplus sa@cl85dev
OSPROCESS OSPROG OSUSER STATUS MACHINE TERMINAL
--------- ----------------------- ------------ -------- ------- ----------
10876 oracle@cass (S001) rholman ACTIVE cass pts/8
1 row selected.
If you look at the program from v$process (OSPROG) you can see the difference
between the two connections. Also a ps -ef|grep oracle will show
protocol information on the internal connection. The machine column for both
of these is the same since I ran them from the console of the same machine.
--
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views,
policies, or procedures of LodgeNet Entertainment Corporation
On Wednesday 18 April 2001 13:21, [EMAIL PROTECTED] wrote:
> 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" <[EMAIL PROTECTED]>
> 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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodd Holman
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
