Re: Question on Extents

There is one potentially serious performance side-effect of large numbers of extents in a single segment. It's documented in a note on my web-site.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Jim Leavitt wrote in message <7b71pg$q14$1_at_brokaw.wa.com>...
>
>Oracle explained that they were not so concerned about the number of
>extents, and in fact recommended that next extent size could be set to some
>small value (say 16K) and that extent size used for every table in the
>tablespace. Then if an extent was freed in one table it became available
for
>all tables (because they all had the same next extent size). You would then
>set the max extents to unlimited for all tables in the tablespace. Further:
>one should not be concerned about hundreds of extents, but rather
thousands!
>I'm sure all this applied to 7 and above.
>
Received on Fri Feb 26 1999 - 15:52:04 CST