4 Replies Latest reply on Aug 5, 2013 8:33 AM by AbuFazal

    Identifying lock held on database at time




      Using oracle and finding that on sat early mornings (3.30 a.m. a table cannot be updated due to an exclusive lock.



      merge into table concerned.


      Nothing else we are aware of accessing table at this time due some process must be due to ORA-00054 - resource busy.


      Is there a way we can identify what caused the lock/causing the lock - happenening each week.