V$log
Check Oracle Data Guard Standby Synchronization Status
Jan 3, 2026 / · 5 min read · v$log v$archive_dest_status Oracle Data Guard Standby Database Database Monitoring Oracle Views DBA Scripts Sequence Numbers Replication ·How to Check Physical Standby Database Synchronization Physical standby databases in Oracle Data Guard need regular monitoring to ensure they stay synchronized with the primary database. The most effective way to check synchronization status is by comparing the current sequence number on the primary database with the …
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 / · 3 min read · oracle database administration performance optimization v$datafile v$tempfile v$logfile v$log v$controlfile dba_free_space ·Investigating Your Oracle Database Files: A Breakdown for Optimization This blog post delves into an Oracle Database code snippet designed to provide valuable insights into your database's storage and activity. We'll dissect its purpose, explain each component, and reveal key points to optimize your database's health …
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 More