Sql-Queries
Oracle Data Guard: V$ARCHIVE_DEST Log Destinations
Jan 5, 2026 / · 4 min read · Oracle Database Data Guard Database Administration Archive Logs Primary Database Monitoring Scripts SQL Queries High Availability v$archive_dest ·Display Log Destinations Options for Oracle Data Guard Primary Database Purpose This SQL script displays detailed information about all configured archive log destinations on an Oracle Data Guard primary database. The query retrieves critical configuration parameters from the V$ARCHIVE_DEST view, allowing database …
Read MoreOracle Time Model Queries: v$sys_time_model Monitoring
Oracle Time Model Queries: System and Session Performance Monitoring Purpose Oracle time model queries provide database administrators with powerful tools to measure and analyze where time is spent within the database system. These queries use two essential dynamic performance views that track accumulated time for …
Read MoreMonitoring Temporary Tablespace Usage in Oracle Database
Jan 31, 2024 / · 3 min read · oracle sql-queries database-administration tablespace segments dba_segments dba_tablespaces v$session v$sort_usage ·Lists the Contents of the Temporary Tablespace(s), Including Details About Each Temporary Object and Its Associated Session Sample SQL Command 1set pages 999 lines 100 2col username format a15 3col mb format 999,999 4select su.username 5, ses.sid 6, ses.serial# 7, su.tablespace 8, ceil((su.blocks * dt.block_size) / …
Read More