This discussion is archived
3 Replies Latest reply: Sep 26, 2012 11:16 AM by Hussein Sawwan-Oracle RSS

finding application user names using   Process id

942941 Newbie
Currently Being Moderated
Hi ,

I have to find out how we can find out application user names. i have written below query ,its giving the username details using process id.

select d.user_name, b.program,b.process,b.sid,b.serial#
from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1)
and b.program like '%JDBC%'
and b.process='29925';

its giviing 6 rows.

when i am quiring the vR$session using same process id , its giving 8 rows.

But my requirement is when i am executing the above query why it has not displaying 8 rows,

and what is the relationship between fnd_logins,fnd_user,v$session and v$process?


I need to find

Edited by: 939938 on Sep 26, 2012 8:41 AM

Edited by: 939938 on Sep 26, 2012 8:53 AM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points