5 Replies Latest reply on Feb 22, 2013 8:05 PM by user2900456

    lock history

    709698
      hi,

      how can i get the blocking lock statistics which were occurred several days back? i want to get the causing sql, user, objects locked etc... i have an awr report taken for that particular time period. im using oracle 11g r2.
      thanks in advance.