V$LOG_HISTORY
Track Current Redo Log Usage with X$KCCCP
Oct 18, 2026 / · 11 min read · Oracle DBA Redo Log Internals X$ Fixed Tables ARCH Process v$log v$logfile v$log_history v$archive_processes x$kcccp ·Track Current Redo Log Usage with X$KCCCP Purpose V$LOG reports a redo log group's allocated size and its status, but it does not report how much of the CURRENT group has actually filled. On a busy instance, that is the number a DBA wants: is the current log close to a switch, or has it barely started filling? V$LOG …
Read MoreCheck Redo Log Switch Frequency with V$LOG_HISTORY
Jul 12, 2026 / · 12 min read · Oracle DBA V$LOG_HISTORY Redo Log Log Switch Frequency Oracle Administration Dynamic Performance Views Redo Log Sizing Oracle Performance v$log ·Check Redo Log Switch Frequency with V$LOG_HISTORY Purpose How many times does the online redo log switch in a single hour, and does that number spike during the nightly batch window or stay flat around the clock? A redo log sizing decision made from a single "switches per day" total hides the answer to that question. …
Read More