From oracle-l-bounce@freelists.org Tue Oct 4 14:19:06 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j94JJ6SM024518 for ; Tue, 4 Oct 2005 14:19:06 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j94JJ2vX024503 for ; Tue, 4 Oct 2005 14:19:02 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 018F31F0983; Tue, 4 Oct 2005 14:18:18 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31476-02; Tue, 4 Oct 2005 14:18:17 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 74D651EB826; Tue, 4 Oct 2005 14:18:17 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=dwCJlchDKCJzcg+WQe4YAgZE6nr2oh+x9bidPfA8srXIyOLCjAGZcjJzwtt4FibZIs10oLJueoL+U3fHr5J1n9v2QuEVcKNgQEgMXuUQ20fbDEIv3YZ1afo5PFL63sX6QfDIg5ZZa212fTm4qUcdzW/Fiuf88KOlOyEU9/kiSXc= Message-ID: <1a3629600510041216n40db60bes22a18d16206daf72@mail.gmail.com> Date: Tue, 4 Oct 2005 15:16:19 -0400 From: Chirag DBA To: ora_forum@yahoo.com Subject: Re: AUTOEXTEND Cc: oracle-l@freelists.org In-Reply-To: <20051004190858.99828.qmail@web34514.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9966_26200743.1128453379472" References: <20051004190858.99828.qmail@web34514.mail.mud.yahoo.com> X-archive-position: 26297 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chiragdba@gmail.com Precedence: normal Reply-To: chiragdba@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.0 required=5.0 tests=AWL,BAYES_00,CLICK_BELOW, HTML_LINK_CLICK_HERE,HTML_MESSAGE autolearn=no version=2.63 ------=_Part_9966_26200743.1128453379472 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline better you keep autoextend so that you don need to wakeup in night only to add the space to tablespace / datafile. still u can control the size of Datafile. regards - chirag On 10/4/05, ora_forum wrote: > > Hi All, > > I have consulting on site and he is trying to convince our management to > use AUTOEXTEND almost on all datafiles and monitor on FS. 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... > > Something else? > Thanks. > > ------------------------------ > Yahoo! for Good > Click here to donate to the > Hurricane Katrina relief effort. > > ------=_Part_9966_26200743.1128453379472 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
better you keep autoextend so that you don need to wakeup in night onl= y to add the space to tablespace / datafile. still u can control the size o= f Datafile.
 
regards - chirag

 
On 10/4/05, = ora_forum <ora_forum@yahoo.co= m> wrote:

Hi All,

 

I have consulting on site and he is trying to convince our manage= ment to use AUTOEXTEND almost on all datafiles and monitor on FS. 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...

Something else?

Thanks.

Yahoo! for Good
Cli= ck here to donate to the Hurricane Katrina relief effort.=20


------=_Part_9966_26200743.1128453379472-- -- http://www.freelists.org/webpage/oracle-l