Re: Extent Allocation

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 5 Jul 2001 13:25:30 -0700
Message-ID: <9i2ifq02un1@drn.newsguy.com>

In article <f98999c8.0107051026.3a0552ca_at_posting.google.com>, jc_va_at_hotmail.com says...
>
>Can someone refresh my memory? If I have a fragmented tablespace, but
>one that includes 100MB of space, all in small chunks, if I go to
>allocated a 50 MB extent, will it fail if it cannot find 50MB of
>contiguous space?
>
>I seem to remember that this was the case with 7.3. It that still the
>case with 8.1.6 and higher?
>
>Thank you.

this is true. you might have 100meg free but not be able to allocate a 10meg extent as extents are contigous collections of blocks in the file.

Locally managed tablespaces in 8i make this concern a thing of the past -- impossible to have a fragmented tablespace with LMT's and uniform extents.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Thu Jul 05 2001 - 15:25:30 CDT