erp管理的几个sql

erp管理的几个sql

erp管理的几个sql

===========================================================

看数据库什么的？
select vss.sid,vss.* from v$process vps ,v$session vss
where vps.spid='&spid'
and vss.PADDR=vps.ADDR


锁住的对象：
SELECT o.object_name,l.session_id,l.process,l.locked_mode FROM v$locked_object l , dba_objects o WHERE

o.object_id=l.object_id


谁在系统中：
SELECT p.pid oracleprocess,s.sid,s.serial#,s.status,s.lockwait,s.process,s.MODULE,s.action,a.user_name,a.user_form_name
FROM v$process p,v$session s,FND_SIGNON_AUDIT_VIEW a WHERE p.addr=s.paddr AND a.pid=p.pid

and s.sid='&sid'
and p.spid='&spid'



查找当前被用户锁定的表:
SELECT dob.OBJECT_NAME Table_Name,lo.SESSION_ID,vss.SERIAL#,vss.action Action,vss.osuser OSUSER,
vss.process AP_PID,VPS.SPID DB_PID
from v$locked_object lo, dba_objects dob, v$session vss, V$PROCESS VPS
where lo.OBJECT_ID = dob.OBJECT_ID
and lo.SESSION_ID = vss.SID
AND VSS.paddr = VPS.addr
order by 2,3,DOB.object_name

已知OS的appl<SID>属主的PID进程查APPS的用户：
select d.user_name "User Name", b.sid SID,b.serial# "Serial#", c.spid "srvPID", a.SPID "ClPID", to_char

(START_TIME,'DD-MON-YY HH:MM:SS') "STime" from fnd_logins a, v$session b, v$process c, fnd_user d
where b.paddr = c.addr and a.pid=c.pid and a.spid = b.process
and d.user_id = a.user_id and (d.user_name = 'USER_NAME' OR 1=1) and a.SPID = & ID

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/133041/viewspace-438544/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/133041/viewspace-438544/