Re: Linking IP address to Oracle process
Date: 1996/11/02
Message-ID: <55fgs5$4l6_at_newton.pacific.net.sg>#1/1
At the client, there should be a file called ORACLE.INI. Edit ORACLE.INI and add the following line under Oracle section
USERNAME=abcd
<abcd> is just any name you can supply with. This you can query through v$session. The column name is OSUSER.
If you enter the IP address of each PC against the USERNAME, then from V$SESION you can issue the following query.
select sid, serial#, username, osuser
FROM V$SESSION
You will know the Oracle userid and the IP address from where the process
is being executed.
We are going to do this in our project.
Hope this info is of some use to you.
Regards
N.Prabhakar DBA
Socgen Crosby Securities
Singapore
Tel : off : 65 - 390 2228
Res : 65 - 560 7785. Received on Sat Nov 02 1996 - 00:00:00 CET