Skip to Main Content
Forums

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 force Oracle to use an Execution Plan?

480239Nov 18 2009 — edited Dec 19 2011
We tried creating SQL Baseline, added all the possible profiles the optimizer dreamt up, and disabled all but the one we wanted it to use. We also set it as FIXED. Oracle still completely ignores the baseline and does it any which way it thinks. How do we force it to use this plan and only this plan for this particular query and ignore changes because of changes in bind variable values?

Thanks a lot.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2012
Added on Nov 18 2009
#general-database-discussions, #sql
17 comments
34,266 views