sys.v_$session table AND oracle8 client [message #55630] |
Wed, 05 February 2003 14:12 |
Tim N.
Messages: 2 Registered: February 2003
|
Junior Member |
|
|
"select Program from sys.v_$session" using the oracle7 client would produce: "\[[server name]][[application.exe]]".
That same "select" statement using the oracle8 client only returns "[[application.exe]]".
Does anyone know how to display the full network path of the [[application.exe]] in the sys.v_$session table using the oracle8 client?
|
|
|
|
|
Re: sys.v_$session table AND oracle8 client [message #55675 is a reply to message #55630] |
Fri, 07 February 2003 05:43 |
Tim N.
Messages: 2 Registered: February 2003
|
Junior Member |
|
|
That gives me the machine name that is USING the application, not the path of where the .exe is located on the file server. None of the fields in the sys.v_$session table contain "exactly" what I need, regarding the oracle8 client. Maybe I need to look somewhere else? Maybe use a package?
|
|
|