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

From: Robert Worreby <Robert.Worreby_at_swisstelecom.com>
Date: 1997/04/30
Message-ID: <3366FF62.36CE@swisstelecom.com>#1/1

Xuewei Zhou wrote:
>
> 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

You can use DBMS_APPLICATION_INFO package to set the MODULE and CLIENT_INFO fields, but not the other ones (all according to Oracle Support).

//Robert Received on Wed Apr 30 1997 - 00:00:00 CDT