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
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博客 ” ，链接：https://blog.itpub.net/133041/viewspace-438544/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
成功完成更换成公司logo
下一篇：
直接重启并发管理器的方法
请登录后发表评论
登录
全部评论
