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
Author: Aamir
![](http://www.aamirharoon.com/wp-content/uploads/2020/12/tobias-fischer-PkbZahEG2Ng-unsplash.jpg)
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
![](http://www.aamirharoon.com/wp-content/uploads/2020/11/lobostudio-hamburg-MAjtbFMV5_k-unsplash-e1608058143645.jpg)
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
![](http://www.aamirharoon.com/wp-content/uploads/2020/11/parallel_plan.png)
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
![](http://www.aamirharoon.com/wp-content/uploads/2020/11/markus-spiske-2VMcpbUR6w8-unsplash-e1608058203745.jpg)
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:
![](http://www.aamirharoon.com/wp-content/uploads/2020/11/Oracle19cupgrade.jpg)
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
![](http://www.aamirharoon.com/wp-content/uploads/2020/10/gold_skins-1-e1608058247195.jpg)
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.
![Photo by Einar Storsul on Unsplash](http://www.aamirharoon.com/wp-content/uploads/2020/10/photo-1546185363-b188cc935569-e1608058035797.jpeg)
….yes, that is correct. 🙂 You can apply an execution plan even if it has been aged out from your local Automatic Workload Repository (AWR).
![](http://www.aamirharoon.com/wp-content/uploads/2016/12/awr_warehouse.png)
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
![](http://www.aamirharoon.com/wp-content/uploads/2016/11/guia-google-analytics.png)
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