eliot06 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 x.ksppinm NAME, y.ksppstvl VALUE, ksppdesc DESCRIPTION
FROM x$ksppi x, x$ksppcv y
WHERE x.inst_id = userenv('Instance')
AND y.inst_id = userenv('Instance')
AND x.indx = y.indx
AND SUBSTR(x.ksppinm,1,1) ^= '_'
ORDER BY 1;
Modify the WHERE clause to minimize what is returned.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Sep 13 2007 - 11:02:33 CDT
