Example on how to pin SQL using SQLPlan Baselines 1) Create a table Table created. 2) Add index to table 3) review explain plan Rerun SQL several times so it becomes eligible for AWR capture 4) get SQLID PREV_SQL_ID is cqx5uak6fvf06 5) run AWR Snap 6) check for SQL in AWR 7) Create STS 8) … Continue reading Oracle SQLPLAN Baseline Example