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

Tag: SQL Query Performance

  • Home
  • SQL Query Performance
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
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

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 2021.
Proudly powered by WordPress | Theme: Fairy by Candid Themes.