Sunday 9 January 2011

Count the concurrent users in apps r12

select count(distinct d.user_name) 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)
Posted by at

1 comment:

  1. pshurreeram8 May 2017 at 02:03

    hi

    your above command gives result - 910
    and select sessions_current from v$license; gives 534

    so what can i conclude please

    ReplyDelete

Subscribe to: Post Comments (Atom)

Number of Visitors