Re: Autoextensible of RBS and Temp datafiles.

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_at_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_at_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_at_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_at_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_at_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_at_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_at_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).