5 Replies Latest reply: Feb 22, 2013 2:05 PM by user2900456 RSS

    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.