Unanswered: ORA-04021: timeout occurred while waiting to lock object <ObjectName>
When trying to drop a package I got an error:
VBO-4552 : PL/SQL package(body) cannot be dropped.
ORA-04021: timeout occurred while waiting to lock object <ObjectName>
Oracle about this says such things:
Data Access Failures Due To Locks
When you issue a SQL statement, Oracle attempts to lock the resources needed to successfully execute the statement. If the requested data is currently held by statements of other uncommitted transactions, however, and remains locked for a long time, a timeout occurs.
Consider the following scenarios involving data access failure:
* Transaction Timeouts
* Locks from In-Doubt Transactions
A DML statement that requires locks on a remote database can be blocked if another transaction own locks on the requested data. If these locks continue to block the requesting SQL statement, then the following sequence of events occurs:
A timeout occurs.
Oracle rolls back the statement.
Oracle returns this error message to the user:
ORA-02049: time-out: distributed transaction waiting for lock
Because the transaction did not modify data, no actions are necessary as a result of the timeout. Applications should proceed as if a deadlock has been encountered. The user who executed the statement can try to reexecute the statement later. If the lock persists, then the user should contact an administrator to report the problem.
So I am an administrator and I don`t know how to unlock a locked package. Could some help me?