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;