Re: where clause filter from an array or use temp table?
- From: Stefan Koehler <contact@xxxxxxxx>
- To: backseatdba@xxxxxxxxx
- Date: Fri, 19 Dec 2014 16:46:36 +0100 (CET)
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: @OracleSK
> Jeff C <backseatdba@xxxxxxxxx> 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@xxxxxxxxx
> <mailto:mauro.pagano@xxxxxxxxx> > 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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
