查询EBS在线用户的数量(ZT)

方法一：
SELECT count(distinct f.user_id)
FROM   V$session s, V$process p, fnd_logins f
WHERE  s.PADDR = p.ADDR
AND    p.PID = f.pid
AND    p.SERIAL# = f.serial#
AND    f.user_id <> 0

方法二：
SELECT fs.USER_NAME,
fu.description,
fs.RESPONSIBILITY_NAME,
fs.USER_FORM_NAME,
fs.TIME,
fs.RESP_APPL_ID,
fs.RESPONSIBILITY_ID,
fs.FORM_ID,
fs.FORM_APPL_ID
FROM FND_SIGNON_AUDIT_VIEW fs,
fnd_user fu
WHERE fs.user_id=fu.user_id
and fs.RESPONSIBILITY_NAME is not null
order by 1;

profile里面Sign-On:Audit Level的site下面要设置成Form

转载于:https://www.cnblogs.com/ebs-blog/archive/2010/09/29/2167296.html