Re: where clause filter from an array or use temp table?

From: Stefan Koehler <contact_at_soocs.de>
Date: Fri, 19 Dec 2014 16:46:36 +0100 (CET)
Message-ID: <1682308589.399842.1419003996637.open-xchange_at_app09.ox.hosteurope.de>



Hi Jeff,
no, the fix_control was introduced with 11.1.0.7 and 11.2.0.1, but it is disabled (0). You can easily check this with view V$SYSTEM_FIX_CONTROL (column VALUE). Output from Oracle 11.2.0.3.6.

SQL> select * from V$SYSTEM_FIX_CONTROL where BUGNO = 6708183;

     BUGNO VALUE SQL_FEATURE DESCRIPTION OPTIMIZER_FEATURE_ENABLE EVENT IS_DEFAULT

---------- ---------- ----------------------------------------------------------------
---------------------------------------------------------------- ------------------------- ---------- ----------
   6708183	    0 QKSFM_DYNAMIC_SAMPLING_6708183				       allow dynamic sampling on table functions							   0	      1


Best Regards
Stefan Koehler

Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK

> Jeff C <backseatdba_at_gmail.com> hat am 19. Dezember 2014 um 16:35 geschrieben:
>
> I checked that note and it says that is fixed in 11.2.0.1
>
> On Fri, Dec 19, 2014 at 6:08 AM, Mauro Pagano <mauro.pagano_at_gmail.com <mailto:mauro.pagano_at_gmail.com> > wrote:
> > > Maybe slightly OT at this point, dynamic sampling on TABLE() is disabled by default and needs a fix to be enabled to kick in (some details
> > > in doc id 6708183.8)

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 19 2014 - 16:46:36 CET

Original text of this message