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 / · 6 min read · oracle sql-queries database-administration tablespace segments dba_segments dba_tablespaces v$session v$sort_usage v$tempseg_usage dba_temp_free_space v$active_session_history ·Lists the Contents of the Temporary Tablespace(s), Including Details About Each Temporary Object and Its Associated Session v$sort_usage is the view to open when TEMP fills up: it holds one row per temporary segment in use, with the user, the session, the tablespace and the blocks allocated. Whether the trigger is an …
Read More