This post highlights the differences between SQL profile and baselines in Oracleยฎ and explains how it works when tuning a query. Optimizer, profile, and baseline…
View More Oracle SQL profile and baselines
Tag: sql profiles
Oracle SQL Profile swapping
SQL tuning is one of the main duty covered by Database Administrator. It is not easy and requires both technology knowledge and sql-development skills. It…
View More Oracle SQL Profile swapping
How to Swap SQL_Profiles?
The central idea behind “swapping” SQL profiles is simple.ย ย You define a SQL profile that specifies the SQL statement that you want to tune, and an…
View More How to Swap SQL_Profiles?
SQL Profiles in the Data Dictionary
In the paper SQL Profiles (page 22) I described the data dictionary tables where the hints belonging to SQL profiles are stored. For example, with the following…
View More SQL Profiles in the Data Dictionary