Re: AUTOALLOACATE vs. UNIFORM extent size in Oracle10g

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Fri, 4 Mar 2011 10:39:52 +0530
Message-ID: <AANLkTimNTVyLt8g3fYYeb1CXY1iZStTFVUKLY-9EC3v9_at_mail.gmail.com>

UNIFORM if record size is not going to change.. On 4 March 2011 00:24, Michael Dinh <mdinh_at_xifin.com> wrote:

> In OLTP and for application, I use AUTOALLOCATE.
>
>
>
> However, there are some tables where the data is transient, then I use
> UNIFORM 64K, but thinking it should have been 1M instead.
>
>
>
> In DW, I use UNIFORM 8M
>
>
>
> 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.
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Mandal, Ashoke
> *Sent:* Thursday, March 03, 2011 10:43 AM
> *To:* exriscer_at_gmail.com; Hemant K Chitale
> *Cc:* Oracle Mailinglist
> *Subject:* AUTOALLOACATE vs. UNIFORM extent size in Oracle10g
>
>
>
> 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.
>
>
>
> Thanks,
>
> Ashoke
>
> [CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email
> is proprietary to Medtronic and is intended for use only by the individual
> or entity to which it is addressed, and may contain information that is
> private, privileged, confidential or exempt from disclosure under applicable
> law. If you are not the intended recipient or it appears that this mail has
> been forwarded to you without proper authority, you are notified that any
> use or dissemination of this information in any manner is strictly
> prohibited. In such cases, please delete this mail from your records. To
> view this notice in other languages you can either select the following link
> or manually copy and paste the link into the address bar of a web browser:
> http://emaildisclaimer.medtronic.com
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 03 2011 - 23:09:52 CST