Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

How to choose good plan, if we have multiple hash values for same SQLID

JhilFeb 21 2024 — edited Feb 23 2024

Dear Experts,

  1. How do i ensure which Hash value or plan is good , if single SQLID has multiple hash values !

    1. After plan fixup, optimizer does not use that good plan but still using previous bad plan, what could be the reason !

    Thanks

Comments
Post Details
Added on Feb 21 2024
0 comments
78 views