How to find the resource causing ORA-00054?
Posted on 2013-05-12
do you have a code that i could use to find which resource is causing a table lock?
i have a packaged procedure which is scheduled to run daily, i get this error ocationally not every day:
-54;ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
i can change the run time of the job to avoid a potential table lock, but i need to find what is causing this error.