Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: _projection_pushdown

Re: _projection_pushdown

From: Anurag Varma <avoracle_at_gmail.com>
Date: Thu, 13 Sep 2007 06:53:36 -0700
Message-ID: <1189691616.220970.217850@g4g2000hsf.googlegroups.com>


On Sep 13, 3:48 am, eliot06 <p.hi..._at_gmail.com> wrote:
> Hi,
> someone could tel me how can i do to see the value of theese
> parameters ?
>
> _OPTIMIZER_MJC_ENABLED
> _projection_pushdown
> _always_anti_join
> _optimizer_transitivity_retain
> _fix_control='4728348:off'
> _optim_peek_user_binds
> _index_join_enabled
>
> thank's

select ksppinm, ksppstvl from sys.x$ksppi n, sys.x$ksppcv v where n.indx = v.indx;

Anurag Received on Thu Sep 13 2007 - 08:53:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US