Re: Force specific plan to be used

If all plans are same, why do you want to force it to "good" cursor. What do you plan to achieve even if you could do that. Also please share why "good cursor" is good and how you derived it.

Rgds,
Sachin Pawar
https://twitter.com/sach_pwr

On Thu, Oct 31, 2019 at 2:03 PM Jeffrey Beckstrom <jbeckstrom_at_gcrta.org> wrote:

> I have a couple of SQL statements that have multiple child cursors. Each
> child cursor has the same plan hash value. The plans all show "this is an
> adaptive plan (rows marked '-' are inactive)". The difference is that on
> the "good" child cursor, the plan also shows "statistics feedback used for
> this statement". Since all of the plans have the same plan hash value, I
> can not use baselines (or can I).
>
> Any suggestions on how to force Oracle to always use the "good" child
> cursor.
>
> Jeffrey Beckstrom
> Lead Database Administrator
> Information Technology Department
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
>

--
http://www.freelists.org/webpage/oracle-l