Re: How to switch the RULE hint in outlines hints in 12.2 on standard edition.

From: <l.flatz_at_bluewin.ch>
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

Original text of this message