We are using Oracle 11.2.0.3. We have a nightly job that drops package through dynamic sql. We sometime get following error. I have not yet been able to reproduce the error.
"
DECLARE
*
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at line 24 "
I checked alert log to find more information on deadlock but could not find anything.
more alert_db1.log| grep ORA-00060 returns nothings. Please suggest what else can I try.