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. David Fitzjarrell ________________________________ From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx> To: mdinh@xxxxxxxxx Cc: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On >Behalf Of Mandal, Ashoke >Sent: Thursday, March 03, 2011 10:43 AM >To: exriscer@xxxxxxxxx; 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 ==============================