oracle workaroud vs patch

  • From: "Hsieh, Joan" <Joan.Hsieh@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 17 Aug 2015 15:36:09 +0000

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2015