Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: LMT's with autoallocate

Re: LMT's with autoallocate

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 4 Nov 2004 15:00:14 -0800
Message-ID: <bf463804110415006439cd26@mail.gmail.com>


I don't believe that anyone has actually supplied sufficient reason for using autoallocate.

Why bother if it can run out of space, even though space is available?

Shades of DD TBS fragmentation...

Jared

On Thu, 4 Nov 2004 16:35:14 -0500, Powell, Mark D <mark.powell_at_eds.com> wrote:
> I saw a demo of this where there were no 64M extents so the object took 8M
> extents and then errored out even though there were still 8M extents left
> after it took so many of them, maybe 128. I do not think that I saved the
> post.
>
> Oracle has stated that the logic behind auto-allocate is subject to change
> without notice so observed behavior may not survive an upgrade.
>
> HTH -- Mark D Powell --
>
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Hand, Michael T
> Sent: Thursday, November 04, 2004 4:14 PM
> To: Oracle-L (oracle-l_at_freelists.org)
> Subject: LMT's with autoallocate
>
> I understand the change in extent size as segments get larger in LMT's with
> autoallocate, but read on a 3rd-party application web site that the smaller
> extent sizes (8M, 1M, 64K) are used if there isn't enough freespace for 64M
> extent. My experiments so far (using allocate extent and table insertion)
> have shown that if there is not 64M of freespace, the process errors out.
> Has anybody heard of this "feature", and under what conditions it manifests
> itself? Or is this unnamed 3rd party smoking something? The platform is
> Tru64 using 9.2.0.5.
>
> Thanks,
> Mike Hand
>
> --
> This transmission is intended only for use by the addressee(s) named herein
> and may contain information that is proprietary, confidential and/or legally
> privileged. If you are not the intended recipient, you are hereby notified
> that any disclosure, copying, distribution, or use of the information
> contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If
> you received this transmission in error, please immediately contact the
> sender and destroy the material in its entirety, whether in electronic or
> hard copy format. Thank you.
>
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 04 2004 - 16:56:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US