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!

how to reuse a good plan hash value for sql statement

Jitendra-OCSep 30 2013 — edited Sep 30 2013

Sql statement is show 2 plan hash value. 1 plan hash value is for good plan another one is for bad plan...........Whiich is takling lot of time to complete sql statement and we have been reported performance issue for this sql. Kindly let me know How can I make sql statement to use good plan .

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 28 2013

Added on Sep 30 2013

#general-database-discussions

6 comments

1,789 views