Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Autoallocate vs Uniform extent performance

Re: Autoallocate vs Uniform extent performance

From: Gaja Krishna Vaidyanatha <oraperfman_at_yahoo.com>
Date: Thu, 03 Apr 2003 09:33:58 -0800
Message-ID: <F001.005798B8.20030403093358@fatcity.com>


Totally agree with Connor. Just to add a comment to his note.

A usage model recommended for UNIFORM vs. AUTOALLOCATE follows:

If you know the data volume and growth of your segments and they are predictable, then use UNIFORM.

If you are completely in the dark with:

  1. How much data is going to be persisted in the segments?
  2. What growth patterns the segments are going to exhibit?

Then use AUTOALLOCATE.

Of course, if you do change your mind, after the fact, you can use the MOVE command to the tablespace of choice with the extent allocation of your choice.

Cheers,

Gaja



Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  INET: oraperfman_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Apr 03 2003 - 11:33:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US