If you really need it, it's still there but starts
with an underscore. Default value 2,000
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
April 2004 Iceland http://www.index.is/oracleday.php
June 2004 UK - Optimising Oracle Seminar
July 2004 USA West Coast, Optimising Oracle Seminar
August 2004 Charlotte NC, Optimising Oracle Seminar
September 2004 USA East Coast, Optimising Oracle Seminar
September2004 UK - Optimising Oracle Seminar
"Dikkie Dik" <dwesteneng_at_mail.com> wrote in message
news:c60oen$6ne2j$1_at_ID-154318.news.uni-berlin.de...
> The optimizer_max_permutations was made for us, but in 10g it is not there
> anymore. Who can tell if it has a successor?
>
> Our query generator trows in a 24 table join, (almost) al of them outer
> joins. ora_prefetch has been disabled, so most likely the exec time is the
> (delayed) parse. And no, I can't change the query generator.
>
> Thanks in advance,
> Dick Westeneng
>
Received on Mon Apr 19 2004 - 11:34:36 CDT
