Finding Owner of Forms Process

Finding Owner of Forms Process

$ ps -ef | grep f60webmx  (on the forms server)

 applmgr 11213     1  0   Dec 10 ?        0:17 f60srvm em=myserv_9000_MYDB

port=9000 mode=socket exe=f60webmx

 applmgr  3276 11213  0 06:33:07 ?        0:15 f60webmx

webfile=5,9067,myserv_9000_MYDB

 applmgr 21199 11213  0 11:13:44 ?        0:47 f60webmx

webfile=5,8876,myserv_9000_MYDB

You can see that Process 11213 (f60srvm) started off processes 3276 and 21199 (among others).... Once you know the UNIX process of the Forms process, you can derive the Oracle Session ID by selecting from v$session where process = (this id). From there on, you can use the following:

select s.sid, user_name, description,

to_char(start_time,'DD-MON-YY HH24:MI:SS') start_time

from applsys.fnd_user u, applsys.fnd_logins l, v$session s, v$process p

where u.user_id = l.user_id

and s.paddr=p.addr  and s.process in ('21199','3276')

and process_spid = p.spid

and start_time > sysdate - 5

and terminal_id != 'Concurrent'

This assumes of course that you have enabled the System profile :

'Sign-On:Audit Level' to at least 'USER'

~~~ Cheers