| 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
Hi,
Unfortunately this doesn't work for NT.
Under NT using 817, the program field from v$process always seems to show
Oracle.exe.
Using v$session.program you can determine if a user is using svrmgrl but I
do not know how to
Also, the terminal and machine fields show the same values.
Is there a solution that will work under NT?
Regards,
Bruce
-----Original Message-----
Sent: Thursday, 19 April 2001 5:46
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 - 18:25:59 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: Reardon, Bruce (CALBBAY) INET: Bruce.Reardon_at_comalco.riotinto.com.au 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).
 |
 |