Günlük bazda REDO LOG geçişlerinin takibi için kullanılabilir.

SELECT TRUNC (FIRST_TIME) DAY,
COUNT (*) NB_SWITCHS,
TRUNC (COUNT (*) * LOG_SIZE / 1024) TOTAL_SIZE_KB,
TO_CHAR (COUNT (*) / 24, '9999.9') AVG_SWITCHS_PER_HOUR
FROM V$LOGHIST, (SELECT AVG (BYTES) LOG_SIZE FROM V$LOG)
GROUP BY TRUNC (FIRST_TIME), LOG_SIZE;