Re: AUTOEXTEND
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Michael McMullen <ganstadba@xxxxxxxxxxx>
- Date: Tue, 4 Oct 2005 14:29:16 -0700
On 10/4/05, Michael McMullen <ganstadba@xxxxxxxxxxx> 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
Other related posts:
