Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Myths
Jonathan Lewis wrote:
> Using 1% is the probably one of the worst
> possible values, as it allows very irritating
> slippage.
>
> Back in the days of 6.0.33, I used to insist
> that 0 was the ONLY sensible value, but eventually
> I worked out after a few years that there was actually
> a good alternative, which was 100%.
>
> Of course, as soon as MINIMUM EXTENT became
> available, it really ceased to matter, beyond the fact
> that any value other than 0 would make smon do
> some pointless work.
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
> Next Seminar - Australia - July/August
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Daniel Morgan wrote in message <3CE918F8.5DC4056B_at_exesolutions.com>...
> > >
> >
> >Because mistakes do happen. And if it takes a few months to find a table
> that
> >slipped by better 1% than 50%. At least that was the thinking.
> >
> >Daniel Morgan
> >
I agree. I was just trying to explain the logic behind the choice of 1% (or illogic as the case may be).
Daniel Morgan Received on Mon May 20 2002 - 11:04:31 CDT