SELECT *
FROM (
SELECT *
FROM DBA_HIST_ACTIVE_SESS_HISTORY
WHERE event = 'deadlock'
ORDER BY sample_time DESC
)
WHERE ROWNUM <= 10;
SELECT *
FROM (
SELECT *
FROM DBA_HIST_ACTIVE_SESS_HISTORY
WHERE event = 'deadlock'
ORDER BY sample_time DESC
)
WHERE ROWNUM <= 10;
Comments
Post a Comment