1 2 Previous Next 16 Replies Latest reply: Aug 5, 2013 9:03 PM by Gamblesk Go to original post RSS
      • 15. Re: Lock Issue.
        sb92075

        application records locks are NOT logged to alert_SID.log file

         

        is table being UPDATED involved in any PK/FK relationship?

        if so, does FK have a supporting INDEX?

        • 16. Re: Lock Issue.
          Gamblesk

          Nothing is going to show up in the Alert log for a problem like this at least given what you have described so far.

           

          If the logs for the application are not showing enough information maybe that logging needs to be improved or modified.

          It might help if you monitor for this scenario and alert someone when it is happening rather than trying to hunt it down after the fact.

           

          Scott

          1 2 Previous Next