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: 9i optimizer permutations

Re: 9i optimizer permutations

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 17 Nov 2001 15:31:44 -0000
Message-ID: <1006012690.24394.0.nnrp-13.9e984b29@news.demon.co.uk>

HP-UX 11 - 64-bit: 2,000

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Connor McDonald wrote in message <3BF133A3.76C4_at_yahoo.com>...

>On my 9i (Win2k), my 'optimizer_max_permutations' seems to default to
>"2000" (contrary to the 80000 of previous Oracle versions and the 9i
>doco).
>
>Can anyone post their value from non-Win2K platforms
>
>Cheers
>Connor
>
>--
>==============================
>Connor McDonald
>
>http://www.oracledba.co.uk
>
>"Some days you're the pigeon, some days you're the statue..."
Received on Sat Nov 17 2001 - 09:31:44 CST

Original text of this message

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