Re: how to populate v$session.machine for SQL*Net connections

From: cwall <cwall_at_petersons.com>
Date: 1997/04/30
Message-ID: <5k85di$72n@news9.noc.netcom.net>#1/1

 Xuewei Zhou wrote in article <5k5l69$t5h_at_z.glue.umd.edu>...
>
>We have problems to identify from which PC a SQL*Net connection is.
>The MACHINE column in v$session is not populated. The TERMINAL column
>always show Windows PC. How can we get the MACHINE column populated
>with a PC's hostname or IP address ? Our PCs only have SQL*Net installed
>and run an application written in SQL Windows.
>
>Any help would be greatly appreciated.
>
>zhou
>

On non-Windows NT machines, I insert the name of the user or other distinctive descriptor in the machine's ORACLE.INI file as in "username = cwall".

/* DEDICATED means connect locally on VMS, via sqlnet v1 or using sqlnet v2 with srvr = DEDICATED option in the connect descriptor.NONE are sqlnet v2 connections not currently servicedby a shared server. SHARED are currently being serviced.

==================================================== */

ttitle center 'SQL*NET Connections' skip 1 - center '$dba_mon:v$session_d.sql' skip 1 - left _date skip 2
column who format a10 heading "Oracle|Username"

column oswho format a10 heading "O/S|Username"
column server format a9 heading "SQLNET|Server"
column status format a8 heading "Status"

column sid format 999 heading "Sess|SID" column user# format 999 heading "Ora|ID" column process format a4 heading "O/S|PID" column terminal format a8 heading "Terminal" column serial# format 9999999 heading "Serial|Killer#" set linesize 132
select server,status,sid,serial#,user#,

substr(process,5,4) process,terminal,
substr(username,1,15) who,substr(osuser,1,8) oswho,
substr(machine,1,7) "Machine",
substr(program,1,45) "Software"

from v$session where type = 'USER'
order by oswho;
prompt
pause Press <RETURN> to exit
exit Received on Wed Apr 30 1997 - 00:00:00 CDT