Re: Which PC is connected

In article <richard_avery-100895074526_at_nnsgm25.lon40.nt.com> richard_avery_at_nt.com (Richard Avery) writes:
>In article <725584852wnr_at_unisol.demon.co.uk>, "D:WINSOCKKA9QSPOOLMAIL"
><mark_at_unisol.demon.co.uk> wrote:
>
>> In a PC-Unix client-server setup using TCP/IP and orasrv how can I
>> deteremine which PC has an open connection to the database ?
>> I can get the process id and some related info from sys.v$session and
>> sys.v$process but I cannot relate an IP address to a particular
>> process.
>>

Mark,

Add the following line to the ORACLE.INI file on eack PC:

USERNAME=MARK and then check the v$session's "terminal" field. It will show "MARK" if the above PC is used to make a connection.

I'm using this setup for a long time now and it works with both sqlnet V1 and V2.

send me an e-mail if you need more info.

Pratul
DBA
AT&T GIS
Columbia SC

appy_at_churchill.columbiasc.attgis.com Received on Thu Aug 10 1995 - 00:00:00 CEST