Month: April 2025
-
Ansible Playbooks for Oracle Grid and Database Release Update (19.26 with MRP & One-Off Fixes)
In this post, I’m sharing the latest Ansible playbooks for patching Oracle Database and Grid Infrastructure, specifically for the Oracle 19.26 Release Update, including MRPs and recommended one-off fixes. Ansible simplifies the patching process, providing repeatability and ease.
-
Disabling the Oracle Compression Advisor
A recent incident regarding tablespace usage occurred during the daily maintenance window, leading to an ORA-1652 error. The issue stemmed from the Compression Advisor creating large CMP3$ tables, causing space pressure in the USERS_XXX tablespace. The problem resolved itself once the advisor completed, freeing up space. With Oracle 12.2+, users can now disable the Compression Advisor specifically without turning off the Segment Space Advisor, offering better management options and addressing similar future issues effectively.
-
SQL Plan Baseline, SQL Patch, SQL Profile: Differences and Use Cases
This content highlights the importance of stability in database performance, especially regarding Oracle’s SQL execution plans, which can fluctuate based on various factors. It focuses on three primary methods for influencing execution plans: SQL Plan Baselines, SQL Patches and SQL Profiles and providing a detailed explanation of how each method functions. It includes a test scenario where all three options are used, demonstrating their behavior. Additionally, it presents a conflicting scenario to help determine the precedence of these methods.
-
Exadata: Configure Management Network Switch with multiple uplinks for redundant connectivity
This post outlines the steps to configure Cisco Management Network Switches with multiple uplinks for redundancy in Oracle Exadata environments. It emphasizes the importance of the Administration Network, which connects all Exadata components for management purposes. Detailed steps are provided for configuring a Cisco 9348 Ethernet Switch, including LACP setup for uplink ports and validating spanning tree settings to ensure stable and reliable connectivity
Osman’s DBlog 