Re: empty program field in v$session.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 16 Sep 2002 22:10:40 +0200
Message-ID: <uocekfm1b6gj5c@corp.supernews.com>

"Marco Blanco" <mblanco_at_performance2000.net> wrote in message news:3d85f9b8_1_at_news.arrakis.es...
> 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.
>
>
>

Likely because those client sessions don't call dbms_application_info. Sql*plus calls dbms_application_info under the covers by default.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon Sep 16 2002 - 15:10:40 CDT