Tag SQL Query Performance

Oracle Database, SQL Query performance

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

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 vendor code). Or a SQL performs better in one database but it is using different…

Aamir
November 9, 2020

Oracle Database 11gR2, Oracle Database 12cR1, SQL Query performance

Apply Execution Plan From Graveyard

….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 first you’ll need a graveyard 🙂 , in other words AWR Warehouse Repository. AWR…

Aamir
February 21, 2017