Re: AUTOEXTEND

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Tue, 4 Oct 2005 15:39:54 -0400
Message-ID: <BAY103-DAV18300656E827A74DE05060A6830@phx.gbl>

How does autoextend relate to full table scan (FTS)? Or, is it bad to FTS the tables that caused multiple autoextends?

Mike
----- Original Message -----

From: Jared Still
To: ora_forum_at_yahoo.com
Cc: oracle-l_at_freelists.org
Sent: Tuesday, October 04, 2005 3:29 PM
Subject: Re: AUTOEXTEND

On 10/4/05, ora_forum <ora_forum_at_yahoo.com> wrote: Hi All,

Could you give me examples why we should not do AUTOEXTENTS? I'm thinking about: 1. Keep all db files 4 GB in size for better maintenance...

If you have tables that are subject to FTS, autoextend is a bad thing.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 04 2005 - 14:42:50 CDT