Re: How to switch the RULE hint in outlines hints in 12.2 on standard edition.
Date: Mon, 24 Jun 2019 12:33:47 +0200 (CEST)
Message-ID: <586617404.19538.1561372427127_at_bluewin.ch>
Hi,
i think it would be much easier to use sql_patch.
Have you tried to refresh dictionary stats though?
Regards
LOthar
----Ursprüngliche Nachricht----
Von : krishsingh.111_at_gmail.com
Datum : 24/06/2019 - 12:23 (MS)
An : oracle-l_at_freelists.org
Betreff : How to switch the RULE hint in outlines hints in 12.2 on standard edition.
Hi Listers,
I am trying to fix a good plan using outlines. But it doesn't seem to work.
CREATE OR REPLACE OUTLINE OUTLINE_GOOD ON select /*+ RULE */ COUNT(9) from user_objects;
CREATE OR REPLACE OUTLINE OUTLINE_BAD ON select COUNT(9) from user_objects;
UPDATE OUTLN.OL$HINTS SET OL_NAME = DECODE(OL_NAME, 'OUTLINE_BAD', 'OUTLINE_GOOD', 'OUTLINE_GOOD', 'OUTLINE_BAD') WHERE OL_NAME IN ('OUTLINE_BAD', 'OUTLINE_GOOD'); COMMIT; Still query is not using RBO ...or RULE hints . i see costing in the execution plan.
I am using this note thorougly (Doc ID 2254235.1)
Can you please suggest.
--
Cheers,
Kunwar
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 24 2019 - 12:33:47 CEST