Received: (qmail 15643 invoked from network); 3 Mar 2011 12:57:15 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 3 Mar 2011 12:57:06 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2A383DAAB19; Thu, 3 Mar 2011 13:55:57 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1299178557; bh=GGK7nlJ04CeS97BG4PlJUP23KZifhBSXW0UUWpWY 410=; h=From:To:CC:Date:Subject:Message-ID:References:In-Reply-To: Content-Type:MIME-Version:Sender:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=GxCxlenS91J8HbljP+1fZgmz6M0opQa4leHwCLP4lrd1ZkQ1wn Y/qRbW5z2YAiYX1Bz7Rcla0+SO8CtEG1PfAYeGvCNZdcIPLl7GeUlL05NiUKWfYY6Kt PPXln9yhMZXPUvWSfw894fSOsUJrGC/4srgf05nv/ApM6WZXzVSZGw= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id dWlgY690yKnO; Thu, 3 Mar 2011 13:55:56 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7A496DAA0CE; Thu, 3 Mar 2011 13:55:13 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 03 Mar 2011 13:54:31 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4FDB5DA9F9A for ; Thu, 3 Mar 2011 13:54:31 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id IiZyHtySP43H for ; Thu, 3 Mar 2011 13:54:31 -0500 (EST) Received: from exchange.xifin.com (exchange.xifin.com [204.182.51.169]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0BE18DA9F88 for ; Thu, 3 Mar 2011 13:54:28 -0500 (EST) Received: from mail02.mba.xifin.com ([172.20.1.42]) by mail02.mba.xifin.com ([172.20.1.42]) with mapi; Thu, 3 Mar 2011 10:54:30 -0800 From: Michael Dinh To: "'ashoke.k.mandal@medtronic.com'" , "exriscer@gmail.com" , Hemant K Chitale CC: Oracle Mailinglist Date: Thu, 3 Mar 2011 10:54:29 -0800 Subject: RE: AUTOALLOACATE vs. UNIFORM extent size in Oracle10g Thread-Topic: AUTOALLOACATE vs. UNIFORM extent size in Oracle10g Message-ID: References: <6548C7B531E1364BAE8F77112F31A1199AD00799@MSPM1BMSGM22.ent.core.medtronic.com> In-Reply-To: <6548C7B531E1364BAE8F77112F31A1199AD00799@MSPM1BMSGM22.ent.core.medtronic.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_D29F9902E534D5478F2E83FD6A44B30625F127406Amail02mbaxifi_" MIME-Version: 1.0 X-archive-position: 34818 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: mdinh@XIFIN.Com Precedence: normal Reply-To: mdinh@XIFIN.Com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --_000_D29F9902E534D5478F2E83FD6A44B30625F127406Amail02mbaxifi_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable In OLTP and for application, I use AUTOALLOCATE. However, there are some tables where the data is transient, then I use UNIF= ORM 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 in= dividual or entity to which it is addressed, and may contain information th= at is privileged, confidential and exempt from disclosure under applicable = laws. BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH INFO= RMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AN= D AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI CO= NTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESS= ARY TO PERFORM YOUR OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE. I= f 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@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Mandal, Ashoke Sent: Thursday, March 03, 2011 10:43 AM To: exriscer@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 ex= tent management in Oracle 10g. I usually use UNIFORM extent size but wonder= ing 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 pri= vate, privileged, confidential or exempt from disclosure under applicable l= aw. 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 u= se or dissemination of this information in any manner is strictly prohibite= d. In such cases, please delete this mail from your records. To view this n= otice in other languages you can either select the following link or manual= ly copy and paste the link into the address bar of a web browser: http://em= aildisclaimer.medtronic.com --_000_D29F9902E534D5478F2E83FD6A44B30625F127406Amail02mbaxifi_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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.<= /span>

 

In DW, I use UNIFORM 8M

 

Michael Dinh

 =

NOTICE OF CONFIDENTIALITY - This material is intended for the u= se of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure und= er applicable laws.  BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTE= CTED HEALTH INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AND AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PAR= TY ANY PHI CONTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXT= ENT 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. Pleas= e notify the sender of the error and delete the e-mail you received. Thank yo= u.

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mandal, Ashoke
Sent: Thursday, March 03, 2011 10:43 AM
To: exriscer@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 ext= ent size but wondering what are the drawbacks for using AUTOALLOACTE.

 

Thanks,

Ashoke

[CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this ema= il 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 privat= e, privileged, confidential or exempt from disclosure under applicable law. If= you are not the intended recipient or it appears that this mail has been forwar= ded to you without proper authority, you are notified that any use or dissemina= tion of this information in any manner is strictly prohibited. In such cases, pl= ease 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 in= to the address bar of a web browser: http://emaildisclaimer.medtronic.com=

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