V$logfile

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 …

List All Standby Redo Logs in Oracle Data Guard Purpose A switchover attempted on a busy Friday afternoon reveals the gap: the standby has been synchronized for months, but no standby redo log group was sized to match the primary's 500 MB online redo logs. The configuration worked fine for the archived-log transport …

Calculating 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 …

Building Remove(rm) or Delete OS Commands for Oracle Database Files (Caution: Destructive) Important Warning: Destructive Operation The provided code snippet demonstrates how to construct operating system (OS) commands for all datafiles, temporary files, log files, and control files within an Oracle Database. However, …

Moving Oracle Database Datafiles and Log Files to Another Disk Where does ALTER DATABASE RENAME FILE get its long list of file names when a database moves from one mount point to another? From v$datafile and v$logfile. This script writes the whole list for you, ready to review and run. Purpose When a database outgrows …

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 …