【Oracle 筆記 】查看 Oracle ERP 線上 User 登入狀況:

查看 Oracle ERP 線上 User 登入狀況:


SELECT fsav.user_name
      ,d.description
      ,fsav.responsibility_name
      ,fsav.user_form_name
      ,TIME
      ,s.SID
      ,s.SERIAL#
      ,s.LOGON_TIME
      ,s.PROGRAM
      ,s.MODULE
      ,s.BLOCKING_SESSION_STATUS
FROM   fnd_signon_audit_view fsav
      ,fnd_user              d
      ,v$process  p
      ,v$session  s
WHERE  d.user_name = fsav.user_name
       AND d.user_name LIKE '01%'
       AND fsav.PROCESS_SPID = p.SPID
       AND fsav.PID = p.PID
       AND p.ADDR = s.PADDR
ORDER BY fsav.user_name

結果:

USER_NAME 0338
DESCRIPTION 堂月立
RESPONSIBILITY_NAME  UP_CO_B
USER_FORM_NAME  Item Costs
TIME 0:0:07
SID 117
SERIAL# 40025
LOGON_TIME 2016/11/1 上午 09:39:41
PROGRAM frmweb@erp.up.com.tw (TNS V1-V3)
MODULE e:BOM:frm:CSTFITCT
BLOCKING_SESSION_STATUS NO HOLDER