Re: Help: Settle an argument regarding EXTENTS

I have read this discussion with great interest, and will read the Cary Millsap paper shortly, but let me put out this simple question:

Does anyone know the maximum size of an extent in Oracle 7.3.4 on Windows NT 4.0?

The only documentation I can find is that files are limited to 2**22 blocks, or 8GB for 2k blocks. But I can't seem to make an extent larger than 2047MB.

I will now go read the paper to find out why I shouldn't even bother trying.

John

In article <922869420.14576.0.nnrp-07.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> Van Messner wrote in message ...
> > A single extent of 60gig is probably not a good idea.
> > He probably has always built tables as he says, and that was standard
> > thinking until maybe six months ago.
>
> That's a sad reflection on how slowly people learn.
> I've been making this point in presentations for
> the many years, people have been announcing it
> in this newsgroup for at least the last 2 years,
> and the Cary Millsap paper you may be thinking
> of is dated March 7th 1996 and that says:
> (I quote):
>
> More and more people have learned that
> multiple extents bear negligible performance
> impact upon all Oracle DML operations.
> .......
> The number of distinct extent sizes in a given
> tablespace should be small; for example, only
> one. If there is more than one extent size in a
> tablespace, then all those extent sizes are
> integral multiples or divisors of each other.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 17:27:11 CST