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: Damien Salvador <damien.salvador_at_via.ecp.fr>
Date: 18 Nov 2001 10:36:17 GMT
Message-ID: <slrn9vf3p1.eig.damien.salvador@zen.via.ecp.fr>


On Sat, 17 Nov 2001 15:31:44 -0000, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> a écrit:
>
>HP-UX 11 - 64-bit: 2,000
>

On AIX (64-bit) it's 80 000.
Can this not be dependant on the kind of database of choose to create ?
>
>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

-- 
Damien
Received on Sun Nov 18 2001 - 04:36:17 CST

Original text of this message

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