Re: where clause filter from an array or use temp table?
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-lReceived on Fri Dec 19 2014 - 16:46:36 CET