Re: empty program field in v$session.

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: Tue, 17 Sep 2002 07:55:03 GMT
Message-ID: <am6nnp$qdh$1@news1.xs4all.nl>

Marco Blanco wrote:

>I am runnin 8.1.6 in OSF1 4.0F and I have some rows in the v$session view
>with null value in the program field. Sometimes this sessions come from NT
>clients and sometimes from other Unix host.
>
>Does anybody know why client sessions do not "write" their names on the
>v$session view?.
>
>Marco Blanco.
>
>
>

Hello Marco,

this is a bug which come up every now and then - it seems to reappear in versions. See for instance bugs# 1237128, 2026123. You cannot change this field programmatically - it is not documented. You can, however, set the module and action columns of v$session, by using the appropriate dbms_application_info calls. SQL*Plus uses this (set appinfo on/off).

Kind Regards,

Herman de Boer
IT Consultancy Group bv Received on Tue Sep 17 2002 - 02:55:03 CDT