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 ==============================