RE: LMT's with autoallocate
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'HANDM@xxxxxxxxxxxx'" <HANDM@xxxxxxxxxxxx>, "Oracle-L (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Nov 2004 16:35:14 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Hand, Michael T
Sent: Thursday, November 04, 2004 4:14 PM
To: Oracle-L (oracle-l@xxxxxxxxxxxxx)
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
