Oracle Apps User Monitor(监控用户)
来源:互联网 发布:linux vi指令什么意思 编辑:程序博客网 时间:2024/06/03 09:26
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”之后,使用脚本监测
- SELECT User_Name,Responsibility_Name,User_Form_Name,TIME,Pid,User_Id,Resp_Appl_Id,Responsibility_Id,Form_Id,Form_Appl_Id
- FROM Fnd_Signon_Audit_View
- ORDER BY To_Number(SUBSTR(TIME, 1, Instr(TIME, ':') - 1)) * 60 * 24 + To_Number(SUBSTR(TIME, Instr(TIME, ':') + 1,
- 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===
- Oracle Apps User Monitor(监控用户)
- Oracle Apps User Monitor(监控用户)
- Oracle 索引监控(monitor index)
- Oracle索引监控(monitor index)
- Oracle索引监控(monitor index)
- Oracle Apps Script to create a new User Login Account
- Linux/Unix shell 监控Oracle实例(monitor instance)
- Linux/Unix shell 监控Oracle监听器(monitor listener)
- Oracle健康监控及健康检查(Health Monitor)
- [Decrypting User Password]How to find password of a User in Oracle Apps R12?
- Oracle Monitor
- 进程单向监控-Monitor
- 进程单向监控-Monitor
- dubbo-monitor监控安装
- Process Monitor监控目录
- Druid Monitor监控
- 详解oracle用户创建(create user)
- linux 下 Oracle 监控sysdba用户登陆
- android application
- 梯度下降
- sgu217:Two Cylinders(simpson积分)
- 托管DLL和非托管DLL的区别
- Vbs脚本经典教材
- Oracle Apps User Monitor(监控用户)
- synchronized 与Lock类
- eclipse导出来javadoc帮助文档
- [学习记录]Xcode的一些快捷按键
- 【学习笔记】JavaScript编码规范-字符串
- c# json数据解析——将字符串json格式数据转换成对象
- 网络编程中出现connection refused错误
- 简易QQ通讯录
- SDP(Session Description Protocol)模型介绍(RFC3264)