Home » Applications » Oracle Fusion Apps & E-Business Suite » how do i get the lock, applications user or batch process lock details
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
Previous Topic: Re: Jobs In Oracle Financials
Next Topic: Oracle DBA w/Financials Needed in NC!!
Goto Forum:
  


Current Time: Mon Jun 14 11:02:22 CDT 2021