Oracle Database Discussions

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!

Restore Old PLAN_HASH_VALUE

947991Sep 21 2012 — edited Sep 21 2012

Hi ,

If I check the PLAN_HASH_VALUE in DBA_HIStory table related to plan , it has a better plan_hash_value and good execution plan.

Same SQL running now using different sql plan. I want this sql should use old plan value , how it is possible ?

if Through SQL Base line , then please provide me steps .

Please suggest.

Regards
Sourabh Gupta

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 19 2012

Added on Sep 21 2012

#general-database-discussions

1 comment

794 views