Knowledge Base : Display Archive Log Switches

30 Juni 16, 2022

How to display archive log switches of an Oracle Database over time, showing the log switch activity per hour?

--https://loopback.org/kb/c/display-archive-log-switches_8159277
 set pages 100
 COL DAY FORMAT a15;
 COL HOUR FORMAT a4;
 COL TOTAL FORMAT 999;
 SELECT TO_CHAR(FIRST_TIME,'YYYY-MM-DD') DAY,
 TO_CHAR(FIRST_TIME,'HH24') HOUR,
 COUNT(*) TOTAL
 FROM V$LOG_HISTORY
 GROUP BY TO_CHAR(FIRST_TIME,'YYYY-MM-DD'),TO_CHAR(FIRST_TIME,'HH24')
 ORDER BY TO_CHAR(FIRST_TIME,'YYYY-MM-DD'),TO_CHAR(FIRST_TIME,'HH24')
 ASC;