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

those MACHINE and TERMINAL columns
are populated automatically whenever SQLNet can identify the machine connection came from. So the solution is to give all PCs a network names, and there won't be any problems.
BTW, the same with OSUSER field.

Serge

Robert Worreby <Robert.Worreby_at_swisstelecom.com> wrote in article <3366FF62.36CE_at_swisstelecom.com>...
> 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