getting program from v$session [message #40853] |
Thu, 07 November 2002 20:02 |
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.
|
|
|
Re: getting program from v$session [message #40868 is a reply to message #40853] |
Fri, 08 November 2002 10:07 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
Are you sure that plus80w.exe is not being called from a shortcut? It should show something. Do you see a .lnk?
Up to 8i, there is no reliable way of determining the program. A user can rename the program or create a shortcut.
|
|
|
Re: getting program from v$session [message #40873 is a reply to message #40853] |
Fri, 08 November 2002 18:35 |
fokker
Messages: 18 Registered: March 2002
|
Junior Member |
|
|
Yes, I am clicking on the executable directly. I also tried moving it around to see if it was some kinda path problem.
To answer your second question, yes I am aware that the user can rename the program, but I'm just going to assume that they won't do somthing like that...
|
|
|