Re: EXPLAIN PLAN : better with RULE!

Jonathan Lewis wrote:
>
> 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
> >

Indeed 1M is possible even with file systems as long you alter the defaults when the file system is created (maxcontig in particular springs to mind if memory serves).

As of most "current" releases of Oracle, 1M is the ceiling.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."