This discussion is archived
4 Replies Latest reply: Aug 5, 2013 1:32 AM by asifkabirdba RSS

Identifying lock held on database at time

user5716448 Explorer
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points