<div>
i think u have got a &nbsp;library cache load lock on that object 
 
try connecting sys user and run the following query while u access the object 
 
select /*+ ordered use_nl(lob pn ses) */ 
&nbsp; &nbsp; &nbsp; &nbsp;decode(lob.kglobtyp, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 
'CLUSTER', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11, 'PACKAGE BODY', 12, 'TRIGGER', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13, 'TYPE', 14, 'TYPE BODY', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 32, 'INDEXTYPE', 33, 'OPERATOR', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40, 'LOB PARTITION', 41, 'LOB SUBPARTITION', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 42, 'MATERIALIZED VIEW', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 43, 'DIMENSION', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 44, 'CONTEXT', 46, 'RULE SET', 47, 'RESOURCE PLAN', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 48, 'CONSUMER GROUP', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 51, 'SUBSCRIPTION', 52, 'LOCATION', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 55, 'XML SCHEMA', 56, 'JAVA DATA', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 57, 'SECURITY PROFILE', 59, 'RULE', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 62, 'EVALUATION CONTEXT', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'UNDEFINED') object_type, 
&nbsp; &nbsp; &nbsp; &nbsp;lob.kglnaobj object_name, 
&nbsp; &nbsp; &nbsp; &nbsp;pn.kglpnmod lock_mode_held, 
&nbsp; &nbsp; &nbsp; &nbsp;pn.kglpnreq lock_mode_requested, 
&nbsp; &nbsp; &nbsp; &nbsp;ses.sid, 
&nbsp; &nbsp; &nbsp; &nbsp;ses.serial#, 
&nbsp; &nbsp; &nbsp; &nbsp;ses.username 
&nbsp; from v$session_wait vsw, 
&nbsp; &nbsp; &nbsp; &nbsp;x$kglob lob, 
&nbsp; &nbsp; &nbsp; &nbsp;x$kglpn pn, 
&nbsp; &nbsp; &nbsp; &nbsp;v$session ses 
&nbsp;where vsw.event = 'library cache lock' 
&nbsp; &nbsp;and vsw.p1raw = lob.kglhdadr 
&nbsp; &nbsp;and lob.kglhdadr = pn.kglpnhdl 
&nbsp; &nbsp;and pn.kglpnmod != 0 
&nbsp; &nbsp;and pn.kglpnuse = ses.saddr 
order by pn.kglpnmod desc, pn.kglpnreq desc
</div>

<div>
<div class="content wysiwyg-content">
Hello, 
 
Some procedure in a database has locked a table, is there a way to know what procedure and from what package, or at least which sql statement has locked it? and How to unlock it? 
 
Thanks in advance
</div>
</div>

Hello,

Some procedure in a database has locked a table, is there a way to know what procedure and from what package, or at least which sql statement has locked it? and How to unlock it?

Thanks in advance

How to know what procedure has locked the table

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.