Re: max INITIAL extent allowable

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Thu, 23 May 2002 03:08:40 -0400
Message-ID: <aci4hq$pqngv$1@ID-82084.news.dfncis.de>

On Wed, 22 May 2002 23:14:06 -0400, Thomas Kyte wrote:

>
> it is a myth that things are better in a single extent.
>

I agree, especially with locally managed tablespaces with the uniform size. That, in particular means that all the extents in the tablespace are of the same size so the situation is similar to the unix file systems which also take advantage of fixed block sizes. The main problem with many extents was the space wastage because the remnants were too small for any reasonable object to use and you ended up with a great deal of space in the extents of 5 blocks in size which you couldn't really use. With locally managed tablespaces, the problem is gone. Even the known developer aversion toward truncating the so called "temporary tables" and proven love for droping & re-creating those is of no consequence in an LMT.
BTW, I see that we're getting back to the good, old BI file in Oracle 9i? (UNDO_MANAGEMENT=AUTO) Received on Thu May 23 2002 - 02:08:40 CDT