Wednesday, February 3, 2021

How to Find oracle locked objects in oracle database

 select object_name obj

 ,oracle_username||' ('||s.status||')' oruser
 ,os_user_name osuser
 ,l.process unix
 ,''''||s.sid||','||s.serial#||'''' ss
 ,r.name rs
 ,to_char(s.logon_time,'yyyy/mm/dd hh24:mi:ss') time
 from v$locked_object l
 ,dba_objects o
 ,v$session s
 ,v$transaction t
 ,v$rollname r
 where l.object_id = o.object_id
 and s.sid=l.session_id
 and s.taddr=t.addr
 and t.xidusn=r.usn
 order by ss, obj,osuser,  obj


alter system  kill session  '6,1509'

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...