RE: AUTOALLOACATE vs. UNIFORM extent size in Oracle10g
- From: Michael Dinh <mdinh@xxxxxxxxx>
- To: "'greg@xxxxxxxxxxxxxxxxxx'" <greg@xxxxxxxxxxxxxxxxxx>, "ashoke.k.mandal@xxxxxxxxxxxxx" <ashoke.k.mandal@xxxxxxxxxxxxx>
- Date: Fri, 4 Mar 2011 09:19:29 -0800
Greg,
Tom Kytes suggest the same.
Can you explain what happens when there is a queue table where the extents are
at 1M or 8M and old data deleted are from 64K extents.
Will those 64K extents be used if let's say no new tables are created and will
this cause a little waste in storage.
Thanks in advance for your response.
Michael Dinh
NOTICE OF CONFIDENTIALITY - This material is intended for the use of the
individual or entity to which it is addressed, and may contain information that
is privileged, confidential and exempt from disclosure under applicable laws.
BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH INFORMATION
(PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AND AGREE AS
FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI CONTAINED HEREIN,
EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESSARY TO PERFORM YOUR
OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE. If the reader of this
email (and attachments) is not the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. Please notify the sender of the error and delete the
e-mail you received. Thank you.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Greg Rahn
Sent: Friday, March 04, 2011 7:53 AM
To: ashoke.k.mandal@xxxxxxxxxxxxx
Cc: exriscer@xxxxxxxxx; Hemant K Chitale; Oracle Mailinglist
Subject: Re: AUTOALLOACATE vs. UNIFORM extent size in Oracle10g
I'd would recommend AUTOALLOCATE over UNIFORM unless you require very
large extents (>64MB). If require larger extents for a segment, just
use the INITIAL attribute.
On Thu, Mar 3, 2011 at 10:42 AM, Mandal, Ashoke
<ashoke.k.mandal@xxxxxxxxxxxxx> wrote:
> I would like find out your personal experience on using AUTOALLOACTE for
> extent management in Oracle 10g. I usually use UNIFORM extent size but
> wondering what are the drawbacks for using AUTOALLOACTE.
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
