RE: Force specific plan to be used
Date: Fri, 1 Nov 2019 11:40:27 -0400
Message-ID: <01fa01d590ca$afa7f030$0ef7d090$_at_rsiz.com>
Excellent suggestion.
Now I haven’t read the full thread yet, but I immediately have 3 questions (that may be in there when I dig):
A wide variety of hilarity can be seen in RAC parallel query NOT forced local on most of 12.1 (and some of 12.2). Hmm actually it can happen forced local on 12.1, but I think that at least was patched for 12.2. A symptom of the BUG I reference would be either parallel forced to serial (having given up trying to get identical FULL HASH on child plans) or a long parse time finally getting the matching children to feed to the coordinator.
That may be a zebra whilst you’re looking for a sick horse, and there are a lot of fine responses from the few I’ve read in the thread, so take my comment with a salt shaker.
mwf
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sayan Malakshinov
Sent: Friday, November 01, 2019 1:23 AM
Hi all,
Since OP is talking about adaptive plans with multiple child cursors, I would check FULL_PLAN_HASH_VALUE and PLAN_HASH_2.
To: breitliw_at_centrexcc.com
Cc: ORACLE-L; JBECKSTROM_at_gcrta.org; tanel_at_tanelpoder.com
Subject: Re: Force specific plan to be used
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 01 2019 - 16:40:27 CET