var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ORA-04021 timeout occurred while waiting to lock object
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.
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,
..it doesn't Work...Still trying for any other solution...
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.