ORA-00060: deadlock detected while waiting for resource
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-00060: deadlock detected while waiting for resource

Hybrid View

  1. #1
    Join Date
    Feb 2006
    Posts
    37

    ORA-00060: deadlock detected while waiting for resource

    I am trying to create a snapshot / materialized view from once instance to another and getting this error message.

    Any ideas what the issue is??? It seems to erroring out at this point:

    SELECT * FROM 'XXXX'.CUSTOMER@XXX.world

    ORA-00060: deadlock detected while waiting for resource
    ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 174
    ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 420
    ORA-06512: at line 1

  2. #2
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Please look at the alert.log and search for ora-0060 there you'll find a reference to a trace file, generated by this error and describing who waits for what and holds what, leading to the dead lock. Then search Metalink for Ora-0060 and I belive you'll find a note describing how to interpret the trace file

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width