RE: AUTOALLOACATE vs. UNIFORM extent size in Oracle10g
- From: Michael Dinh <mdinh@xxxxxxxxx>
- To: "'ashoke.k.mandal@xxxxxxxxxxxxx'" <ashoke.k.mandal@xxxxxxxxxxxxx>, "exriscer@xxxxxxxxx" <exriscer@xxxxxxxxx>, Hemant K Chitale <hemantkchitale@xxxxxxxxx>
- Date: Thu, 3 Mar 2011 10:54:29 -0800
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
Other related posts:
