--1查找系统用户基本信息
SELECT user_id,
user_name,
description,
employeE_id,
person_party_id
FROM fnd_user;
--3查找所有的interface表
SELECT *
FROM dba_objects db
WHERE db.object_type = 'TABLE'
AND db.object_name LIKE '%INTERFACE%';
--4查找对应模块的interface表
SELECT *
FROM dba_objects db
WHERE db.object_type = 'TABLE'
AND db.object_name LIKE '%INTERFACE%'
AND owner LIKE 'PO';
--5查找用户当前的状态
SELECT substr(v$session.username, 1, 8) username,
v$session.osuser osuser,
-- DECODE(V$SESSION.SERVER,'DEDICATED','D','SHARED','S','O') SERVER,
v$sqlarea.disk_reads disk_reads,
v$sqlarea.buffer_gets buffer_gets,
substr(v$session.lockwait, 1, 10) lockwait,
v$session.process pid,
v$session_wait.event event,
v$sqlarea.sql_text SQL
FROM v$session_wait, v$sqlarea, v$session
WHERE v$session.sql_address = v$sqlarea.address
AND v$session.sql_hash_value = v$sqlarea.hash_value
AND v$session.sid = v$session_wait.sid(+)
AND v$session.status = 'ACTIVE'
AND v$session_wait.event != 'client message'
ORDER BY v$session.lockwait ASC, v$session.username;
--6查找用户的职责
SELECT c.user_name A
EBS系统管理常用SQL语句整理汇总(参考网上资料&其他人博客)
最新推荐文章于 2022-05-19 17:38:32 发布
本文整理了EBS系统管理中常用的SQL查询语句,包括查找系统用户、Interface表、用户状态、职责、组织信息、物料单位、库存信息等关键操作,助你高效管理EBS系统。
摘要由CSDN通过智能技术生成