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: AUTOEXTEND

Re: AUTOEXTEND

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 4 Oct 2005 14:29:16 -0700
Message-ID: <bf46380510041429w72b8c919n1cc775e3fab6f200@mail.gmail.com>


On 10/4/05, Michael McMullen <ganstadba_at_hotmail.com> wrote:
>
> How does autoextend relate to full table scan (FTS)? Or, is it bad to FTS
> the tables that caused multiple autoextends?
>
>

If you know a table will be large, and will be subject to FTS, allocating the
space all at once will make it contigous.

The impact of not doing so is probably not all that bad. It is much like the multiple extents argument. ie. you usually don't need to worry about it.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 04 2005 - 16:32:00 CDT

Original text of this message

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