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

Category: Oracle Database

  • Home
  • Oracle Database
Oracle Database Oracle Database 19c

Oracle Standby Database Parameters in PDB

January 30, 2022April 22, 2022 Aamir

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

Read More
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

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

  • Oracle Standby Database Parameters in PDB January 30, 2022
  • 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
  • LinkedIn
  • twitter
  • facebook
All Rights Reserved 2021.
Proudly powered by WordPress | Theme: Fairy by Candid Themes.