How to get last 10 deadlock in Oracle

 SELECT *

FROM (

  SELECT *

  FROM DBA_HIST_ACTIVE_SESS_HISTORY

  WHERE event = 'deadlock'

  ORDER BY sample_time DESC

)

WHERE ROWNUM <= 10;

Comments