multiple accepted plans for a give statement
From: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
Date: Tue, 28 Sep 2021 11:58:21 +0000
Message-ID: <DM6PR09MB4677BFCB41321776041E491BDFA89_at_DM6PR09MB4677.namprd09.prod.outlook.com>
If I have sql for which I have accepted more than one plan in the baseline, how does Oracle decide which of the accepted plans in the baseline to use?
Date: Tue, 28 Sep 2021 11:58:21 +0000
Message-ID: <DM6PR09MB4677BFCB41321776041E491BDFA89_at_DM6PR09MB4677.namprd09.prod.outlook.com>
If I have sql for which I have accepted more than one plan in the baseline, how does Oracle decide which of the accepted plans in the baseline to use?
Jeffrey Beckstrom
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 28 2021 - 13:58:21 CEST