3 Replies Latest reply: Sep 26, 2012 1:16 PM by Hussein Sawwan-Oracle RSS

    finding application user names using   Process id

    942941
      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.pid=c.pid
      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?

      Thanks,
      DBA


      I need to find

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

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