| Finding forms user name/form name [message #231354] |
Mon, 16 April 2007 12:55  |
madchaz
Messages: 65
Registered: October 2005
|
Member |
|
|
First, I'm not sure this is the right place to ask, so if it isn't, mods, fell free to move this to the right place.
I am working on a query to get session informations out of the system. Right now, I have been able to get pretty much everything I wanted out of it, but 2 pieces of information are missing for me.
I need to be able to find the form name and form user name of database sessions caused by a session in Oracle forms.
I'm trying to figure out what view/table can give me this info.
Right now, I'm getting my information from the following 4 views.
v$session_event
v$session
v$session_wait
v$process
I'm using the sid+serial# of the session as a primary key.
I can get the forms user name from v$session's action column, but that requires some string manipulation. I can,t get the full form name. Any ideas would be welcome
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
