Changing IP Addresses in Oracle 11g RAC Environments
IP Address Types in Oracle 11g RAC
Oracle 11g RAC utilizes several distinct IP address categories:
Public IP: Used for normal cluster operations and client connections
Virtual IP (VIP): Provides failover capabilities for application connections
Single Client Access Name (SCAN) VIP: Allows clients to connect using a single name regardless of cl ...
Posted on Mon, 28 Sep 2026 16:47:44 +0000 by wisewood
Deep Dive into Oracle 11g AWR Report Metrics and Optimization
Report Overview and Core Metrics
An Automatic Workload Repository (AWR) report requires a minimum of two snapshots to generate meaningful delta statistics. These snapshots must belong to the same database instance without an intermediate restart. The report calculates metrics by comparing the end snapshot values against the start snapshot value ...
Posted on Thu, 23 Jul 2026 16:05:27 +0000 by coolfool