| how do i get the lock, applications user or batch process lock details [message #367221] |
Wed, 17 May 2000 11:56 |
Kaarina
Messages: 1
Registered: May 2000
|
Junior Member |
|
|
how do i get the lock, applications user or batch process lock details from oracle applications database.
the version i created below makes double entries and misses out locks caused by reports on Rel 11.
thanks
select
s.sid sid
, s.serial# serial
, substr(u.user_name,1,12) locked_by
, to_char(s.logon_time,'DD. - HH24:MI:SS') logon
, to_char(sysdate - s.last_call_et / 86400,'DD. - HH24:MI:SS') lastcall
, substr(s.username,1,8) o_user
, s.osuser os_user
, s.status status
from v$session s
, v$process p
, v$lock l
, apps.fnd_logins n
, apps.fnd_user u
where s.paddr = p.addr
and s.process = n.spid -- so we don't get hung sessions with old SID and SERIAL
and p.pid = n.pid
and n.user_id = u.user_id
and l.sid = n.pid
and l.block is not null
order by
to_char(s.logon_time,'DD. - HH24:MI:SS') desc, u.user_name
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
