EBS系统管理常用SQL语句整理汇总（参考网上资料&其他人博客）

--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