Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Location
    Noida
    Posts
    1

    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
    Posts
    17

    Arrow

    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:

    $ORACLE_HOME/rdbms/admin/dbmslock.sql

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

    Best Regards,
    Krishna.

Posting Permissions

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