Scripts

How to Cancel Oracle Data Guard Managed Recovery Overview The ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL command stops the Managed Recovery Process (MRP) on an Oracle Data Guard physical standby database. This command is essential when you need to perform maintenance operations, open the database in …

Removing Standby Database Apply Delay in Oracle Data Guard Purpose This script removes the apply delay from an Oracle Data Guard physical standby database. Apply delays are safety features that create a time lag between when redo data arrives at the standby database and when it is applied, protecting against corrupted …

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 …

Generate Active Session History ASH Report in Oracle Database Users say the application froze for four minutes at 10:42 and then recovered. An hourly AWR report will average that spike away. An Active Session History (ASH) report built for 10:40 to 10:50 shows which sessions, SQL statements and wait events were active …

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 …

Enable or Disable Oracle GATHER_STATS_JOB for Automatic Statistics Collection Purpose Two Oracle releases, two different switches. In Oracle Database 10g, automatic optimizer statistics ran as a Scheduler job named GATHER_STATS_JOB, and you turned it on or off with DBMS_SCHEDULER.ENABLE and DBMS_SCHEDULER.DISABLE. From …

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 …

Oracle AWR Create Baseline for Performance Monitoring DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE What is Oracle AWR Create Baseline The DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE procedure creates a baseline by preserving a specific range of AWR snapshots for future performance comparisons. A baseline protects performance …

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 …

How to Manually Take an AWR Snapshot in Oracle Database with dbms_workload_repository.create_snapshot What is Oracle AWR Snapshot Creation? Creating a manual AWR snapshot in Oracle Database allows database administrators to capture performance statistics at specific points in time, providing precise data for …