Step 6: Consider Plan History
Plans can change. To see what changed and when:
SELECT *
FROM dba_hist_sql_plan
WHERE sql_id = '<your-sql-id>'
ORDER BY plan_hash_value, timestamp;
Look for:
- Plan changes over time
- Elapsed time or row differences across plans