Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to prevent a bad Hash Plan from being used.

Tater_SaladMar 15 2018 — edited Mar 27 2018

Hi We're using Oracle 11.2. We have a bad hash plan that's causing a query to run too long. We want to delete that hash plan so it won't be used again.

Does anyone know how to do this? I know you can delete a bad tunning session using:

BEGIN dbms_sqltune.drop_tuning_task('Bad Tunning Session'); END;

But what if all you have is a bad hash plan?
This post has been answered by AndrewSayer on Mar 16 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2018
Added on Mar 15 2018
13 comments
8,395 views