SELECT U.USER_NAME,
APP.APPLICATION_SHORT_NAME,
FAT.APPLICATION_NAME,
FR.RESPONSIBILITY_KEY,
FRT.RESPONSIBILITY_NAME,
FFF.FUNCTION_NAME,
FFT.USER_FUNCTION_NAME,
ICX.FUNCTION_TYPE,
ICX.FIRST_CONNECT,
ICX.LAST_CONNECT
FROM ICX_SESSIONS ICX,
FND_USER U,
FND_APPLICATION APP,
FND_APPLICATION_TL FAT,
FND_RESPONSIBILITY FR,
FND_RESPONSIBILITY_TL FRT,
FND_FORM_FUNCTIONS FFF,
FND_FORM_FUNCTIONS_TL FFT
WHERE 1 = 1
AND U.USER_ID = ICX.USER_ID
AND ICX.RESPONSIBILITY_APPLICATION_ID = APP.APPLICATION_ID
AND FAT.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID
AND FAT.LANGUAGE = 'ZHS'
AND FR.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID
AND FR.RESPONSIBILITY_ID = ICX.RESPONSIBILITY_ID
AND FRT.LANGUAGE = 'ZHS'
AND FRT.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID
AND FRT.RESPONSIBILITY_ID = ICX.RESPONSIBILITY_ID
AND FFF.FUNCTION_ID = ICX.FUNCTION_ID
AND FFT.FUNCTION_ID = ICX.FUNCTION_ID
AND ICX.DISABLED_FLAG != 'Y'
AND ICX.PSEUDO_FLAG = 'N'
AND (ICX.LAST_CONNECT +
DECODE(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),
NULL,
ICX.LIMIT_TIME,
0,
ICX.LIMIT_TIME,
FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT') / 60) / 24) >
SYSDATE
AND ICX.COUNTER < ICX.LIMIT_CONNECTS;
备注:是从DBA大哥那获取到的,又加工了一下,是山寨版的原创!
SELECT FND.USER_NAME,
ICX.RESPONSIBILITY_APPLICATION_ID,
ICX.RESPONSIBILITY_ID,
FRT.RESPONSIBILITY_NAME,
ICX.SESSION_ID,
ICX.FIRST_CONNECT,
ICX.LAST_CONNECT,
DECODE((ICX.DISABLED_FLAG), 'N', 'ACTIVE', 'Y', 'INACTIVE') STATUS
FROM FND_USER FND, ICX_SESSIONS ICX, FND_RESPONSIBILITY_TL FRT
WHERE FND.USER_ID = ICX.USER_ID
AND ICX.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID
AND ICX.DISABLED_FLAG <> 'Y'
AND TRUNC(ICX.LAST_CONNECT) = TRUNC(SYSDATE)
ORDER BY ICX.LAST_CONNECT;
监控concurrent 正在执行的sql
SELECT a.sid, a.serial#, b.sql_text
FROM v$session a, v$sqltext b
WHERE a.sql_address = b.address
AND a.sid = <...>
ORDER BY b.piece
查询某用户一年登录EBS失败的次数:
用 apps/apps_password 登录:
SQL>select count(login_name)
from fnd_unsuccessful_logins l, fnd_user u
where l.user_id = u.customer_id
and attempt_time > (select max(start_time)
from fnd_logins l
where l.user_id = u.user_id)
and (attempt_time + 265) > SYSDATE
and u.user_name = '<username>';
另外如果查询登录成功的次数, 可以查询表dns_logins
分享到:
相关推荐
EBS R12 通知列表设置 通过个性化配置,实现通知列表首页展示
EBS R12安装,EBS R12安装EBS R12安装windows
Oracle EBS R12 升级 流程图
Profile 是 Oracle EBS R12 中的一种配置文件,用于存储用户的个人配置信息。Profile 中的配置信息将影响用户的使用体验,例如语言、时区、货币等。 在 Profile 中,我们可以找到许多配置项,例如: * USER_...
ORACLE EBS R12用户指南中文 Oracle® Cost Management User's Guide Release 12 Part No. B31271-02
ORACLE EBS R12 安装步骤详解,讲述ORACLE EBS R12的详细安装步骤,感觉不错,和大家一块分享
ORACLE EBS R12.1.3 克隆详细步骤 该文档描述了Oracle 应用R12系统的克隆过程。 文档内容适用于所有12.x.x版本,例如12.0,12.0.4和12.1.x。在适用的部分,12.0.x系列统称为12.0版本,而12.1.x系列统称为12.1版本。...
Oracle EBS R12与11i文件系统差异
修改EBS R12服务器域名的操作方法,包括AP服务器和DB服务器,域名、IP都可以改,改IP相对容易一些,改域名就要牵涉到很多配置,该文档都讲到了,按照上面介绍的操作错不了的。
R12数据字典
EBS R12 总账 应收 应付 税 基本设置
非常完整,根据ebs各个模块整理而成的数据字典,共Oracle ebs二次开发人员参考,不希望到处乱传,更不希望被CSDN拿来赚钱
应用开发员手册_R12-官方文档,是EBS 开发人员必备手册.版本为R12版本。
本文详细描述EBS R12设置文档,包含SYS,GL,INV,AP,PO,AR,OM模块的设置步骤
R12 EBS 系统管理员 EBS administrator guide ORACLE
Oracle_EBS_R12_操作手册的中文操作手册,适合对R12的入门学习
EBS R12 解决方案: •案例介绍及Oracle工程制造整体解决方案; •Oracle项目制造解决方案; •Oracle采购解决方案; •Oracle设备管理解决方案; •Oracle财务解决方案; •Oracle R12产品趋势
EBS R12 INVENTORY 培训教材(英文)
Oracle EBS R12 DBA 原厂教材
ORACLE EBS-R12-设置文档_税信息设置详细手册_V1.0