SQLs that run smoothly from time to time suddenly slow down. When we investigate, we see that the SQL Plan has changed. Now, what I want from you is how to determine the efficient plan_hash_id and how to apply it again.
Do you have any nice SQL scripts to do that..?