Improve Reliability in PostgreSQL 17: Leveraging Logical Replication Failover
PostgreSQL 17 introduced the sync_replication_slot parameter, a game-changing feature to maintain logical replication continuity during failovers or major upgrades.
The Database Handyman
Cloud Architecture. Open-Source Databases. Data-Driven Solutions.
The Database Handyman
Cloud Architecture. Open-Source Databases. Data-Driven Solutions.
Oracle Standby Database Parameters in PDB
In multi-tenant Active Data Guard database configuration, setting PDB parameters for standby PDB is not trivial. I discover this when we opened the Standby database in read only mode and resource manager plan was not set. I used Franck Pachot…
Upgrade Standby Database
In this post, I am sharing my notes on upgrading Oracle Standby database. Following are the steps I preformed on standby database while upgrading from 12.1 to 19.5 but these can be used for upgrading any standby database version. I…
Patch Oracle GI and DB Software Only And Create Gold Image
At work I had to install (but not fully) Oracle Software (GI and DB) for AMI (Amazon Machine Image). Downloading and unzipping software is easy but we wanted to have Oracle Software patched. So every time AMI is deployed, we…
Enforce Execution Plan of “hinted” SQL To “non-hinted” SQL
Sometimes a SQL performs better when given an Optimizer hint. However in some scenarios it is not possible to modify the SQL (maybe it is vendor code). Or a SQL performs better in one database but it is using different…
Unified Auditing
In this blog post I am sharing my notes about Unified Auditing. It shows how to enable and purge Unified Audit data. From Oracle Documents: What Is Unified Auditing? In unified auditing, the unified audit trail captures audit information from…
Before Upgrading to 19c
Make sure to checkout following Oracle Document before upgrading Grid Infrastructure / ASM and/or databases to 19c. It will save you a lot of headache 🙂 . Patches to apply before upgrading Oracle GI and DB to 19c or downgrading…
OEM 13.3 Gold Agent Image
Just a quick blog about creating Gold Agent Image in OEM 13.3. I was getting error when creating Gold Agent Image and cause wasn’t obvious. So I start digging through log files and found that following file which is owned…
Apply Execution Plan From Graveyard
….yes, that is correct. 🙂 You can apply an execution plan even if it has been aged out from your local Automatic Workload Repository (AWR). But first you’ll need a graveyard 🙂 , in other words AWR Warehouse Repository. AWR…
AWR Warehouse Repository Cleanup
Recently I was testing AWR Warehouse functionality at work and had to re-configure the AWR Repository database due to a firewall issue which caused me to change the database port number. Anyways, when I re-configured the AWR Warehouse database, I…