Re: Oracle Myths

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

>