Message-ID: <F001.00425912.20020312063339@fatcity.com>
Date: Tue, 12 Mar 2002 06:33:39 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Bunyamin K. Karadeniz" <bunyamink@havelsan.com.tr>
Subject: Re: Autoextensible of RBS and Temp datafiles.
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit

thank you ...


Bunyamin K. Karadeniz           
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu 
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729

The degree of normality in a database 
is inversely proportional to that of its DBA.

----- Original Message ----- 
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sent: Tuesday, March 12, 2002 3:58 PM


> Personal feeling is to keep them autoextend=NO
> 
> if they can extend indefinitely, you can get a runaway query that takes
> up all the space in either of them without being stopped by lack of
> space.
> 
> However, having said that, there are sometimes reasons to allow them to
> extend and it depends entirely on your applications and databases.
> 
> 
> --- "Bunyamin K. Karadeniz" <bunyamink@havelsan.com.tr> wrote:
> > Dear Gurus, 
> > I am always making RBS and TEMP tablespaces set as
> > Autoextensible=false. 
> > Is it true ? or logical?
> > 
> > 
> > 
> > Bunyamin K. Karadeniz           
> > Oracle DBA / Developer
> > Civilian IT Department
> > Havelsan A.S. Eskisehir yolu 
> > 7.km Ankara Turkey
> > Phone: +90 312 2873565 / 1217
> > Mobile : +90 535 3357729
> > 
> > The degree of normality in a database 
> > is inversely proportional to that of its DBA.
> > 
> > 
> > 
> > 
> 
> > ATTACHMENT part 2 image/gif name=dbainblk.gif
> > The previous attachment was filtered out by the ListGuru mailing
> > software at fatcity.com because binary attachments are not
> > appropriate
> > for mailing lists.  If you want a copy of the attachment which was
> > removed, contact the sender directly and ask for it to be sent to
> > you by private E-mail.
> > 
> > This warning is inserted into all messages containing binary
> > attachments which have been removed by ListGuru.  If you have
> > questions
> > about this message, contact Postmaster@fatcity.com for clarification.
> > 
> 
> > ATTACHMENT part 4 image/gif name=tech.gif
> 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Try FREE Yahoo! Mail - the world's greatest free email!
> http://mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: wisernet100@yahoo.com
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru@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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bunyamin K. Karadeniz
  INET: bunyamink@havelsan.com.tr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@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).