Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: _projection_pushdown
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