Re: Why some optimizer features are available in Oracle 8.0 and 9 but not in 8.1?

I don't have access to all these database versions to double-check, but try to use the static view sys.x_$ksppi to see ALL the initialization parameters, including the "hidden" ones (the ones where the column KSPPINM starts with an underscore). I suspect that maybe these parameters were "hidden" in 8.1.

Daniel

Julien Viala <i_at_hate.spam> wrote in message news:<3ECC9F5B.5050507_at_hate.spam>...
> Hi everyone,
>
> Does anyone know why some optimizer features like 'complex view merging' or 'push-join predicate' are available for Oracle 8.0 and 9 but not for 8.1?
> Additional question (the answer is probably no but...) : is there a way to get them in 8.1 ?
>
> Thanks
>
> Julien VIALA
Received on Fri May 23 2003 - 12:49:01 CDT