V$log
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 MoreCheck Oracle Data Guard Standby Synchronization Status
Jan 3, 2026 / · 9 min read · Sequence Numbers Oracle Data Guard Standby Database Database Monitoring v$log v$archived_log v$archive_dest_status v$dataguard_stats v$dataguard_process ·Check Oracle Data Guard Standby Synchronization Status Purpose Is the physical standby caught up with the primary? The fastest first answer is a pair of numbers: the log sequence the primary is writing now, and the newest log sequence the standby has applied. If the two are close, redo is flowing and being applied. If …
Read MoreCalculating Redo Log File Sizes in Oracle Databases Maintaining optimal performance in your Oracle database often involves careful monitoring of various components. Redo log files, crucial for recovery, require attention to ensure they're sized appropriately. In this post, I'll share a code snippet to list redo log …
Read MoreOracle: List Datafiles, Tempfiles, and Logfiles with Sizes
Mar 26, 2024 / · 8 min read · oracle storage v$datafile v$tempfile v$logfile v$log v$controlfile dba_free_space ·Oracle: List Datafiles, Tempfiles, and Logfiles with Sizes Purpose Capacity planning starts with one number: how much disk the database files use. Oracle spreads that answer over several dynamic performance views. V$DATAFILE lists the datafiles, V$TEMPFILE the tempfiles, V$LOGFILE the redo log members and V$CONTROLFILE …
Read MoreAssessing Database Storage Utilization in Oracle Database
Dec 31, 2023 / · 3 min read · Database Size Free Space Used Space v$datafile v$tempfile v$log dba_free_space ·How large is the Oracle Database? Gain a comprehensive overview of database size, free space, and used space to proactively manage storage resources and plan for future growth. SQL Code 1col "Database Size" format a20 2col "Free space" format a20 3col "Used space" format a20 4select round(sum(used.bytes) / 1024 / 1024 …
Read MoreOracle DBA SQL Scripts and Database Commands
Oracle SQL Scripts and Database Commands 23c 21c 19c 18c 12c 11g 10g 9i 8i We are in the process of building a list of simple scripts used every day by DBA and others. If you have your own scripts you reuse in a text file on you workstation please send it to us. To look at other scripts see the Oracle Scripts Tag …
Read More