Re: Linking IP address to Oracle process

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/02
Message-ID: <55fgs5$4l6@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 CST