Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011

    Unanswered: Deadlock contion in procedure

    Hi All,

    I have a stored procedure in which I am getting deadlock condition, Can any one let me know in oracle 10g how can I detect it.

  2. #2
    Join Date
    Apr 2011


    hi yogendra.

    the deadlock in Oracle result in this error :

    ORA-00060: deadlock detected while waiting for resource

    caused by competing resources or competing DML running against same data.Look at the Trace File to see the transaction and resources involved.
    you can also identify the deadlocks using following script:


    Log on as SYS or as SYSDBA authority and run this script in all may need to run this script for deadlock monitoring numerous times before you identify the trasaction that is causing the problem.

    Best 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