Oracle Apps User Monitor(监控用户)

Monitor Users

如何监控当前哪些用户在干什么，Oracle Apps提供了一个监控用户这么功能（尽管还是比较简陋）。使用系统管理员用户登陆，到System Administrator职责下，Security > User > Monitor，然后F11, Ctrl-F11,就可以看到当下有哪些用户在干什么，比如这里的截图，用户PROJMFG在Order Information Super User职责下

监控的粒度是由系统Profile “Sign-On:Audit Level”(这个配置的中文名叫“登录：审计层”)来控制的

• NONE - No monitoring.
• USER - Will only show you a list of logged in users.
• RESPONSIBILITY - Will show you the user logged in and the responsibility they are using.
• FORM - Will go down to the lowest level of detail and show you the User, Responsibility and Form being accessed.

另外监控用户还可以使用11i : Oracle Application Object Library Active Users Data Collection Test (Doc ID 233871.1)里说的方法，它会输出一个html格式的report，展示当前Active的User数据

这里还可以在设置好Profile “Sign-On:Audit Level”之后，使用脚本监测

1. SELECT User_Name,Responsibility_Name,User_Form_Name,TIME,Pid,User_Id,Resp_Appl_Id,Responsibility_Id,Form_Id,Form_Appl_Id  
2. FROM Fnd_Signon_Audit_View  
3. ORDER BY To_Number(SUBSTR(TIME, 1, Instr(TIME, ':') - 1)) * 60 * 24 + To_Number(SUBSTR(TIME, Instr(TIME, ':') + 1,   
4.      Instr(TIME, ':', Instr(TIME, ':') + 1) - (Instr(TIME, ':') + 1))) * 60 + To_Number(SUBSTR(TIME, Instr(TIME, ':', Instr(TIME, ':') + 1) + 1));  

Kill User Session

如果你想断掉用户的进程，可以用下边的方法：
&PID=Oracle Process ID
&USER_NAME=User Name

SELECT SUBSTR(d.user_name,1,30) "User Name"
             ,      a.pid
             ,      b.sid
             ,      b.serial#
             FROM   v$process a, v$session b, fnd_logins c, fnd_user d
             WHERE  a.pid = c.pid
             AND    c.pid = &PID
             AND    d.user_name = UPPER('&USER_NAME')
             AND    d.user_id = c.user_id
             AND    a.addr = b.paddr
             AND    c.end_time IS NULL
记录下SID and SERIAL# 用于下边的SQL，
ALTER SYSTEM KILL SESSION '123, 1234';       --   <'SID, SERIAL#'>

Signon Audit Report

"Monitor User"用于监控当下系统中在线用户的行为情况，那么如何查看过往用户行为的历史情况，Oracle提供了几个Report。

Signon Audit Concurrent Requests (shows who submitted what requests)

Signon Audit Forms (shows who accessed what forms)

Signon Audit Responsibilities (shows who accessed what responsibilities)

Signon Audit Unsuccessful Logins (shows who unsuccessfully attempted to sign on as another user)

Signon Audit Users (shows who signed on to Oracle Applications)

中文：

以Signon Audit Forms为例

Report运行的结果

通过脚本查看在线用户

How to check how many users in Oracle Apps System now ：http://blog.csdn.net/pan_tian/article/details/8299654

参考：

How do you audit an Oracle Applications' user? [ID 395849.1]
Monitor Application Users does not Display All Users Signed On [ID 1014948.6]
Monitor User Form Does Not Retrieve Records [ID 144742.1]
Auditing: How Do I Audit Responsibilities and Data? [ID 436316.1]
How To Audit Data Changes In Tables Using Triggers [ID 1025832.6]

Oracle Applications System Administrator's Guide - Security Release

转自：http://blog.csdn.net/pan_tian/article/details/7876135
===EOF===