Re: Extent Allocation

In article <f98999c8.0107051026.3a0552ca_at_posting.google.com>, Buck Turgidson <jc_va_at_hotmail.com> writes:
>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.

Yes, I believe that it is safe to say that if a space request 50M for is made and a 50M extent does not exist to meet the request that an error will be returned when dictionary management is involved. With locally managed tablespaces if uniform extents are in use then Oracle will take your 50M request and break it into how many uniform extents it takes to meet your request. Eventually if the tablespace no longer has free space to give an error will be generated. I am not sure how Oracle handles a storage request on a new object when automatic extent allocation is in use.

• Mark D Powell --
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net