Force specific plan to be used
From: Jeffrey Beckstrom <jbeckstrom_at_gcrta.org>
Date: Thu, 31 Oct 2019 14:02:08 -0400
Message-Id: <5DBB21A00200000B000644A2_at_groupwise2014.gcrta.org>
Date: Thu, 31 Oct 2019 14:02:08 -0400
Message-Id: <5DBB21A00200000B000644A2_at_groupwise2014.gcrta.org>
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-lReceived on Thu Oct 31 2019 - 19:02:08 CET