Locked Object


** if locked_Mode is high(6) >3 ,heavy DML operaton..Tranctional lock

SELECT d.OBJECT_ID, substr(OBJECT_NAME,1,20), l.SESSION_ID, l.ORACLE_USERNAME, l.LOCKED_MODE
from   gv$locked_object l, dba_objects d
where  d.OBJECT_ID=l.OBJECT_ID;


 Lock with time frame 
column Mode format a4;
column SID format 999;
column Minutes format 9999999;
select /*+RULE */ s.username, o.name "Locked object", l.sid, l.type, round(l.ctime/60,0) "Minutes",
decode(l.lmode,'1','-','2','RS','3','RX','4','S','5','SRX','6','X') "Mode",
 substr(s.osuser,1,10)"OS user",
substr(machine,1,12) "Machine", substr(terminal,1,10) "Terminal"
from v$locked_object lo, v$lock l, v$session s, sys.obj$ o
where l.sid = lo.session_id
and l.sid > 5
and (l.id2 = lo.xidsqn
 or l.id1 = lo.object_id)
and s.sid = lo.session_id
and o.obj# = lo.object_id;

alter system kill session '2288,397,immediate';


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

Use the V$ACCESS view to see which users have locks on which objects in your database
 
 col OBJECT for a40
 SELECT SID, OWNER, OBJECT, TYPE
 FROM V$ACCESS
 WHERE OBJECT='IMEC_IMAGE_PDF_CONVERSION';

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

Last ddl

select object_name, object_type, last_DDL_TIME, TIMESTAMP, STATUS
from dba_objects
where object_name = 'PO_DOCUMENT_ACTION_PVT'

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

Case Study 
It's probably another package being called with in

PO_DOCUMENT_ACTION_PVT lets see what do_action is in POXVDACB.pls

It calls a LOT of packages one of them must be invalid.

select object_name, object_type, status, last_ddl_time
from dba_objects
where status = 'INVALID'
and Object_type like '%PACKAGE%'
Order by object_name


especially in interested in PO_ and FND_ invalids this package may be calling



We should check your versions too, please run and upload

To check source query 
 select *
from dba_source
where name = 'PO_DOCUMENT_ACTION_PVT'
and line =2

----------------------
select * from dba_source where name='KAREDL';