I get the below error every week in DAC and its been repetitive these days. What we do is restart the job after some time and it runs successfully.
9426 SEVERE Sun Mar 16 03:03:36 CDT 2014
ANOMALY INFO::: DataWarehouse:TRUNCATE TABLE W_AP_XACT_FS
MESSAGE:::ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired.
Since this error related to database. I have checked with my DBA's and they are also not sure why this is coming repetitively.
I have checked the previous posts on this and I could find the below link. Where the solution for this is stated as to restart the job. And the other one was to clearup archive logs. I have checked with DBA and we got the info that the database which we are using is not in archive mode. So this solution rules out in our case.
Please share our ideas on this if you have faced similar kind of this issue before.
its because you are running some workflows which uses the same table at the same time which might have started in parallel. So the other workflow/session which still holds the lock on the table and didn't commit the data yet. So its better to wait for sometime and then re-run the failed session so by the time the lock is released on the table. Check the SA's which you have added which use same table simultaneously