本文介绍了一种方法，通过脚本统计Oracle企业业务套件（EBS）系统的用户登录情况，帮助管理员了解用户活动频率和时间分布。
每日用户登录次数的统计
select to_char(START_TIME,'DD-MON-YYYY') Login_Time, count(*) cnt
from apps.fnd_logins where START_TIME > (select to_date('01-APR-2015 00:00:00','DD-MON-YYYY HH24:MI:SS') from dual)
and login_type is not null
and end_time is null
group by to_char(START_TIME,'DD-MON-YYYY')
order by Login_Time DESC;
from apps.fnd_logins where START_TIME > (select to_date('01-APR-2015 00:00:00','DD-MON-YYYY HH24:MI:SS') from dual)
and login_type is not null
and end_time is null
group by to_char(START_TIME,'DD-MON-YYYY')
order by Login_Time DESC;
最低0.47元/天 解锁文章
628
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
