Re: AUTOALLOACATE vs. UNIFORM extent size in Oracle10g
Date: Fri, 4 Mar 2011 06:10:18 -0800 (PST)
I don't understand your comment as record size directly relates to db_block_size with regard to row chaining/migration. Variable extent sizes won't mitigate row chaining for variable sized records but a larger block size might, depending upon the length of the largest record, as there is a maximum block size of 32k that can be defined.
From: Subodh Deshpande <deshpande.subodh_at_gmail.com> To: mdinh_at_xifin.com
Cc: Oracle Mailinglist <oracle-l_at_freelists.org> Sent: Thu, March 3, 2011 11:09:52 PM
Subject: Re: AUTOALLOACATE vs. UNIFORM extent size in Oracle10g
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
>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.
>[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-lReceived on Fri Mar 04 2011 - 08:10:18 CST