| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:Direct Vs. SQL*net
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
OSPROCESS OSPROG OSUSER STATUS MACHINE TERMINAL --------- ----------------------- ------------ -------- ------- ---------- 22446 oracle_at_cass (TNS V1-V3) rholman ACTIVE cass pts/8
1 row selected.
RESULTS from net8 connection:
$. oraenv
$sqlplus sa_at_cl85dev
OSPROCESS OSPROG OSUSER STATUS MACHINE TERMINAL --------- ----------------------- ------------ -------- ------- ---------- 10876 oracle_at_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 rodney.holman_at_lodgenet.com 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, dgoulet_at_vicr.com wrote:Received on Wed Apr 18 2001 - 15:07:24 CDT
> 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.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: rodney.holman_at_lodgenet.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).
 |
 |