Re: Detecting program name on logon.

From: Lionel Mandrake <nobody_at_nospam.noway.nohow>
Date: Wed, 24 Oct 2001 02:57:52 GMT
Message-ID: <3BD62E62.3080100@nospam.noway.nohow>

If you include calls to the Oracle-supplied dbms_application_info package (ie, the 'set_module' procedure) in your code, you can put "custom" info into v$session and then easily find other instances of you application. Of course, this assumes you control the source code...

HTH vdolt wrote:

> I have a program that constantly connects to the database and hangs
> resources
> for the database. It is using JDBC client, so all information in
> V$SESSION is non-specific (there is no terminal, os_user or any other
> fields). It is also using generic user name that other programs use.
> All I have to go by is the external program name (it says ORACLE.EXE
> (P001)). I wanted to come up with the after logon trigger that would
> disconnect session with such a program name.
> However, in the userenv there is no program name attribure, there is
> also no sessionid so that I can reference V$SESSION.
> ANy ideas on how I can do that?
> Thanks.
>
Received on Tue Oct 23 2001 - 21:57:52 CDT