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: EXPLAIN PLAN : better with RULE!

Re: EXPLAIN PLAN : better with RULE!

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 18 Jul 2002 12:43:23 +0100
Message-ID: <1026992832.23504.0.nnrp-01.9e984b29@news.demon.co.uk>

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 ...

>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
>
Received on Thu Jul 18 2002 - 06:43:23 CDT

Original text of this message

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