Skip to content
  • About Me
  • Search Results
  • LinkedIn
  • twitter
  • facebook

The Database Handyman

My notes about Oracle Database, APEX, OEM Cloud Control and whatever I learn

Author: Aamir

  • Home
  • Aamir
Oracle Database Oracle Database 19c Upgrade

Upgrade Standby Database

December 6, 2020December 7, 2020 Aamir

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

Read More
Oracle Database Oracle Database 19c

Patch Oracle GI and DB Software Only And Create Gold Image

November 24, 2020November 23, 2020 Aamir

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

Read More
Oracle Database SQL Query performance

Enforce Execution Plan of “hinted” SQL To “non-hinted” SQL

November 9, 2020November 29, 2020 Aamir

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

Read More
Oracle Database 12cR1 Oracle Database 19c

Unified Auditing

November 4, 2020November 4, 2020 Aamir

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:

Read More
Oracle Database 19c Upgrade

Before Upgrading to 19c

November 2, 2020November 2, 2020 Aamir

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

Read More
OEM Cloud Control

OEM 13.3 Gold Agent Image

October 30, 2020October 30, 2020 Aamir

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. 

Read More
Photo by Einar Storsul on Unsplash
Oracle Database 11gR2 Oracle Database 12cR1 SQL Query performance

Apply Execution Plan From Graveyard

February 21, 2017December 25, 2020 Aamir

….yes, that is correct. 🙂 You can apply an execution plan even if it has been aged out from your local Automatic Workload Repository (AWR).

Read More
OEM Cloud Control 12c

AWR Warehouse Repository Cleanup

December 9, 2016 Aamir

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

Read More
SQL Query performance

Correlated Subquery to Analytics

November 25, 2016October 31, 2020 Aamir

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

Read More
Oracle Database 11gR2

Oracle 11gr2 Dataguard – Resolving ORA 19909

October 21, 2016October 29, 2020 Aamir

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

Read More

Posts navigation

1 2 3 Next

About Me

I am a Principal Database Engineer. I like working on query performance tuning, database optimization and new challenges. I also architect database designs and help developers build efficient applications.

  • facebook
  • twitter
  • linkedin

Recent Posts

  • Upgrade Standby Database December 6, 2020
  • Patch Oracle GI and DB Software Only And Create Gold Image November 24, 2020
  • Enforce Execution Plan of “hinted” SQL To “non-hinted” SQL November 9, 2020
  • Unified Auditing November 4, 2020
  • Before Upgrading to 19c November 2, 2020
  • LinkedIn
  • twitter
  • facebook
All Rights Reserved 2020.
Proudly powered by WordPress | Theme: Fairy by Candid Themes.