oracle用户登录统计,Oracle EBS用户登录情况统计脚本

以下是Oracle EBS用户登录情况的统计脚本：

SELECT 
   fu.user_name "User Name", 
   fr.responsibility_name "Responsibility Name",
   fiv.description "Application Name",
   to_char(fa.logon_time,'DD-MON-YYYY HH24:MI:SS') "Logon Time",
   to_char(fa.logoff_time,'DD-MON-YYYY HH24:MI:SS') "Logoff Time",
   trunc(fa.logoff_time - fa.logon_time) "Duration"
FROM 
   fnd_logins fa, 
   fnd_user fu, 
   fnd_responsibility_vl fr, 
   fnd_application_vl fiv
WHERE 
   fu.user_id = fa.user_id 
   AND fiv.application_id = fr.application_id 
   AND fr.responsibility_id = fa.responsibility_id
   AND fa.logon_time BETWEEN TRUNC(SYSDATE-7) AND TRUNC(SYSDATE)+1
ORDER BY 
   fa.logon_time DESC;

该脚本将显示过去7天内Oracle EBS用户的登录情况，包括用户名，责任名称，应用程序名称，登录时间，注销时间和持续时间。请注意，您需要具有足够的权限才能运行此脚本。