ITPub博客

首页 > 数据库 > Oracle > How to check how many users in Oracle Apps System now

How to check how many users in Oracle Apps System now

原创 Oracle 作者:pan_tian 时间:2014-07-02 15:04:03 0 删除 编辑


select 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);


<!-- Baidu Button BEGIN -->

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26687597/viewspace-1204639/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: Inventory Transfer To GL(11i)
下一篇: Profile:"Hide Diagnostics menu entry"
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2012-02-18

最新文章