<div>
Try to increase the value of DML_LOCKS in the init.ora and u can get v$session,V$lock.
</div>


Try to increase the value of DML_LOCKS in the init.ora and u can get v$session,V$lock.

<div>
This errors means that there are some other user accessing that object.<br />
<br />
Try looking at v$access for the users (sessions) that access that object.<br />

</div>


This errors means that there are some other user accessing that object.

Try looking at v$access for the users (sessions) that access that object.


<div>
<div class="content wysiwyg-content">
Sometimes when I compile a package, Toad locks up and eventually times out with ORA-04021: timeout occurred while waiting for a lock on object ...<br />
<br />
How do I know what session is blocking the compile? OEM lock manager does not seem to show anything.<br />
<br />
Also, this particular package is used infrequently, has no package variables, and when it is used, the action takes only a few seconds and is always committed. It seems strange that there should be any contention for this object. What's happening here?<br />

</div>
</div>


Sometimes when I compile a package, Toad locks up and eventually times out with ORA-04021: timeout occurred while waiting for a lock on object ...

How do I know what session is blocking the compile? OEM lock manager does not seem to show anything.

Also, this particular package is used infrequently, has no package variables, and when it is used, the action takes only a few seconds and is always committed. It seems strange that there should be any contention for this object. What's happening here?


DDL Locks

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.