2 Replies Latest reply on Jan 13, 2020 9:53 AM by 3244661

    increase open cursor in init.ora can resolve deadlock issue?

    user6255101
    user6255101 Dec 30, 2019 3:20 PM

      We have EBS 12.2 on LINUX server.  Every day at least two to three dead lock happen.

      My friend told me increase open_Cursors on init.ora can resolve deadlock issue.

       

      is it true?

       

      Thanks

      • 53 Views
      • Tags:
        • 1. Re: increase open cursor in init.ora can resolve deadlock issue?
          dmillerp
          dmillerp Dec 30, 2019 4:21 PM (in response to user6255101)

          Very doubtful, IMHO.  That's not good if these are standard Oracle processes running that are creating the deadlock.  A typical deadlock means Transaction A needs to get data that is being held by Transaction B whilst Transaction B needs to get data being held by Transaction A.  Neither transaction can proceed without one of the sessions terminating.  I'm not a DBA...but my experience has always been that one transaction has to be killed (and when Oracle detects it they kill both).  I look forward to a DBA's more technical reponse!

          • 2. Re: increase open cursor in init.ora can resolve deadlock issue?
            3244661
            3244661 Jan 13, 2020 9:53 AM (in response to user6255101)

            Hi,

             

              Increasing open_cursor will not help to resolve deadlock issue, it might help to resolving exceeding maximum cursor issue.

             

            with regards to deadlock, its happening by inefficient transactions and would be resolved by oracle itself.

             

            when you find deadlock happen, then check the  sessions are being accessed same objects by v$aceess.. and tune the transaction as changing the transaction timings.