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
I attended a session in Oracle Open World 2016 given by Kyle Hailey. In his presentation Kyle talked about how to measure database performance and