Home » SQL & PL/SQL » SQL & PL/SQL » getting program from v$session
getting program from v$session [message #22971] Thu, 07 November 2002 20:01 Go to next message
fokker
Messages: 18
Registered: March 2002
Junior Member
Hi I'm querying the v$session view, and I find that not all applications provide a value in the program field. For instance, when I use the plus80w.exe, program is null, but when I use sqlplusw.exe, then the name shows up. Is there any way to set this information upon logging in, or get this information somehow? Thanks, in advance.

Report message to a moderator

Re: getting program from v$session [message #22979 is a reply to message #22971] Fri, 08 November 2002 06:01 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hello,
Check wether u can do this by handling After Logon trigger

sai

Report message to a moderator

Re: getting program from v$session [message #22985 is a reply to message #22979] Fri, 08 November 2002 18:32 Go to previous message
fokker
Messages: 18
Registered: March 2002
Junior Member
The problem is that when I use an after logon trigger there is no way to tell what app is being used to connect if the program is null in the v$session. This is the information that I am trying to get.

Report message to a moderator

Previous Topic: Oracle equivalent of an old Centura SQL function
Next Topic: getting program from v$session
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 07:05:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.