4 Replies Latest reply: Aug 5, 2013 3:32 AM by asifkabirdba RSS

    Identifying lock held on database at time

    user5716448

      Hi,

       

      Using oracle 11.2.0.3 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.

       

      Thanks