When executing the oracle procedure which calls a java function I am getting an error ORA-04021 timeout occurred while waiting to lock object .

How to release the lock forcibly to execute the trigger.


Need Help.

You may try to query the view V$ACCESS and see if someone is using the object where you get the lock.

Then you may try to wait them to end their work or KILL them if you own the rights.

another option you can test is to
alter system flush shared_pool

this command clears all the shared pool, so its content needs to be re-created (a performance issue.)

let me know if this works,

astropp

Hi Astropp..

..it doesn't Work...Still trying for any other solution...



Regds
Sethu

Do u know which object is being locked, are u trying to
obtain an exclusive lock on a table inside the procedure.
Procedures are pinned in SGA and then a lock is obtained on it
so that it cannot be modified during execution.