oracle归档日志检查

oracle归档日志检查

查看归档日志的生成速度

SELECT THREAD#, MAX(SEQUENCE#) AS "LAST_SEQ_ARCHIVED",
(SELECT MAX(SEQUENCE#) FROM V$LOG WHERE THREAD# = A.THREAD#) AS "LAST_SEQ_CURRENT",
(SELECT COUNT(*) FROM V$ARCHIVED_LOG WHERE THREAD# = A.THREAD#) AS "NUM_ARCHIVED",
(SELECT COUNT(*) FROM V$LOG WHERE THREAD# = A.THREAD#) AS "NUM_LOGS",
ROUND((SELECT COUNT(*) FROM V$ARCHIVED_LOG WHERE THREAD# = A.THREAD#) / (SELECT COUNT(*) FROM V$LOG WHERE THREAD# = A.THREAD#) * 100, 2) AS "PERCENT_ARCHIVED"
FROM V$ARCHIVED_LOG A
GROUP BY THREAD#;

这将显示每个线程（THREAD#）的归档日志情况，包括最后一个归档的序列号（LAST_SEQ_ARCHIVED），当前日志的最大序列号（LAST_SEQ_CURRENT），已归档的日志数量（NUM_ARCHIVED），当前日志的数量（NUM_LOGS）和归档率（PERCENT_ARCHIVED）

查看归档日志的使用情况

SELECT NAME, SPACE_LIMIT, SPACE_USED, SPACE_RECLAIMABLE
FROM V$RECOVERY_FILE_DEST;