Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXPLAIN PLAN : better with RULE!
On Sun, if not others, 1MB is legal and possible when using (logical) raw devices.
-- Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminars UK July / Sept Australia August Malaysia September USA (MI) November http://www.jlcomp.demon.co.uk/seminar.html Telemachus wrote in message ...Received on Thu Jul 18 2002 - 06:43:23 CDT
>As far as I remember
>won't it (invisibly) scale D_F_M_R_C back so that
> D_F_M_R_C * blocksize < max allowed for the OS ?
>
>and isn't 32 ok for a 2k block size ?
>
>however if it's a 16k block size then as Sybrand says it's a bad idea ...
>
>the biggest legal D_F_M_R_C * blocksize I've seen is 256K
>