DBA
Oracle Export and Import via Gzip Named Pipe
Mar 1, 2026 / · 5 min read · oracle database backup compression unix dba export-import shell-scripting ·Oracle Database Export and Import to Gzip Through a Named Pipe When you need to export a large Oracle database but do not have enough disk space for a full uncompressed dump file, piping the export directly through gzip using a Unix named pipe is a proven technique. This method compresses data on the fly, producing a …
Read MoreList Backup of Archivelog All: Oracle RMAN Command Guide
Feb 9, 2026 / · 9 min read · Oracle RMAN Backup Archive Logs Database Administration Recovery DBA Scripts v$backup_set rc_backup_set v$archived_log ·List Backup of Archivelog All: Oracle RMAN Command Guide Purpose Which archived redo logs does RMAN know how to restore? The LIST BACKUP OF ARCHIVELOG ALL command answers that question. It reads the RMAN repository and prints every backup that holds archived redo logs, one backup set at a time, with the thread and …
Read MoreHow to Create Oracle RMAN Recovery Catalog Step by Step
Jan 6, 2026 / · 5 min read · Oracle RMAN Database Backup Recovery Catalog DBA Database Administration Oracle Scripts Backup Strategy ·How to Create Oracle RMAN Recovery Catalog Step by Step Purpose The Oracle Recovery Manager (RMAN) recovery catalog is a dedicated database schema that stores metadata about backup and recovery operations for one or more target databases. This script demonstrates how to create a recovery catalog by establishing a …
Read MoreHow to Check Oracle Database Role Using V$DATABASE View
Jan 1, 2026 / · 3 min read · Oracle Data Guard DBA SQL Query Database Administration V$DATABASE Standby Database Primary Database ·How to Check Oracle Database Role Using V$DATABASE View Purpose The SQL query SELECT database_role FROM v$database is a fundamental Oracle Database command used to determine the current operational role of a database instance. This query is essential for Database Administrators (DBAs) working with Oracle Data Guard …
Read MoreOracle Data Guard Standby Database Startup Commands
Oct 23, 2025 / · 6 min read · Oracle Data Guard Standby Database Database Recovery High Availability Backup DBA SQL Commands v$archive_dest_status v$database ·Oracle Data Guard Standby Database Startup Commands Oracle Data Guard standby database startup commands enable database administrators to initialize and maintain physical standby databases that provide disaster recovery and high availability for production systems. These three essential commands work together to bring …
Read MoreHow to Remove an Oracle AWR Baseline Using DROP_BASELINE
Sep 30, 2025 / · 4 min read · Oracle AWR Database Performance DBA PLSQL Performance Tuning Baseline Management Workload Repository dba_hist_baseline dba_hist_snapshot dbms_workload_repository ·How to Remove an Oracle AWR Baseline Using DROP_BASELINE Purpose The DROP_BASELINE procedure removes a previously-defined AWR (Automatic Workload Repository) baseline from an Oracle database. This command is essential for database administrators who need to conserve storage space by deleting unused or outdated …
Read MoreList All Oracle AWR Baselines Using DBA_HIST_BASELINE
Sep 28, 2025 / · 5 min read · Oracle AWR Performance Tuning Database Administration SQL Scripts Baseline Management Performance Monitoring DBA DBA_HIST_BASELINE ·List All Oracle AWR Baselines Using DBA_HIST_BASELINE This SQL script retrieves all AWR baselines stored in an Oracle Database, displaying critical information about each baseline including its identifier, name, and associated snapshot range. AWR baselines preserve specific periods of database performance statistics …
Read MoreOracle AWR Interval and Retention: DBA_HIST_WR_CONTROL
Sep 24, 2025 / · 6 min read · Oracle Database AWR Performance Tuning Database Administration SQL Scripts Monitoring Workload Repository DBA dba_hist_wr_control ·How to Check Oracle AWR Snapshot Interval and Retention Settings using table dba_hist_wr_control Purpose The Oracle Database Automatic Workload Repository (AWR) is a critical component for performance monitoring and database tuning that automatically collects and stores performance statistics at regular intervals. This …
Read MoreOracle Statspack Installation Guide: spcreate Setup
Sep 5, 2025 / · 8 min read · oracle database performance monitoring administration dba statspack tuning dbms_job dba_jobs ·Oracle Database Statspack Installation Guide - Complete Setup and Configuration Purpose Statspack is a snapshot-based way to see what an Oracle database did between two points in time. AWR is the better-known alternative, and the license position differs. Oracle's Licensing Information guide lists the Automatic …
Read MoreOracle Statspack: List Snapshots with stats$snapshot
Sep 4, 2025 / · 3 min read · oracle statspack performance monitoring dba sql snapshots administration v$database ·How to List Oracle Statspack Snapshots with SQL Query This Oracle Database query provides a simple way to view all Statspack snapshots stored in your database. Statspack is Oracle's built-in performance monitoring tool that captures database statistics at regular intervals, helping database administrators analyze …
Read More