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

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

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

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:

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

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.

….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

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

At work I came across a query that was using correlated sub select and I thought it is worth sharing. I have seen many queries
Just wanted to write quick blog about an error we got on Standby Database and steps I performed to resolved it. Saved me from re-building