oracle workaroud vs patch
From: Hsieh, Joan <Joan.Hsieh_at_tufts.edu>
Date: Mon, 17 Aug 2015 15:36:09 +0000
Message-ID: <416FB269D9362D4AA40BE7124CA3EF9F3520E4A8_at_SSVMEXDAG01MB02.tufts.ad.tufts.edu>
Hi,
Date: Mon, 17 Aug 2015 15:36:09 +0000
Message-ID: <416FB269D9362D4AA40BE7124CA3EF9F3520E4A8_at_SSVMEXDAG01MB02.tufts.ad.tufts.edu>
Hi,
Our 12.1.0.2 database seems to hit the bug 18430870<https://support.oracle.com/rs?type=bug&id=18430870>, ADAPTIVE PLAN AND LEFT JOIN GIVE WRONG RESULT, there is a workaround to set the optimizer_adaptive_features=false, also, there is a patch that Oracle provides to fix the bug. I'd like to know what's pro's and con's for the 2 approaches. Should the work around is sufficient to deal with this bug?
Thanks,
Joan
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 17 2015 - 17:36:09 CEST