Oracle SQL Plan management

Jul 31, 2024 · 7 min read · Case #1: When both good and bad plan are in the cursor cache Let's say I have this query and it has two execution plans for query sql_id=9676c891uwzv6, both currently in the cursor cache: select sql_id, plan_hash_value, first_load_time, ...