Re: PROGRAM Field of v$Session

From: Mladen Gogala <mgogala_at_earthlink.net>
Date: Sun, 13 Jan 2002 07:14:36 GMT
Message-ID: <pan.2002.01.13.02.14.13.727318.4807@earthlink.net>

On Fri, 11 Jan 2002 16:35:31 -0500, Maddalena Capp wrote:

> Windows 8.1.5 Server & Windows 8.1.5/7 Client
>
> Can anyone tell me why sometimes after establishing a connection to an
> Oracle Server from a Windows application (even SQL-Plus), the PROGRAM
> field of v$session is NULL.
>
> This appears to be intermitent. Sometimes it's fine, ie shows
> SQLPLUSW.EXE.
>
> We would like to use this view as the basis for a concurrent user control
> system.
>
> Any help on this would be appreciated.
>
> Thanks
>
> Adrian
>

The program field is set by the programs known to oracle and I don't know how to set it. What you can do is to a MODULE filed by using the DBMS_APPLICATION_INFO PL/SQL package which can set the module field within V$SESSION and you can use it instead of the PROGRAM field. The package is described in the oracle supplied packages refrence.

-- 
Mladen Gogala

Received on Sun Jan 13 2002 - 01:14:36 CST