Oracle-L: Re: System Tablespace and Autoextend

From: <JApplewhite_at_austin.isd.tenet.edu>
Date: Thu, 24 Oct 2002 12:14:37 -0800
Message-ID: <F001.004F2F2F.20021024121437@fatcity.com>

Sam,

Autoextend caused tablespace corruption for me once, but it was over 5 years ago with Personal Oracle 7.3.2.3 on Win95 - not the most reliable OS that Oracle has ever ported to. ;-)

We have several 8.1.7 databases here, on both Win2k and HPUX. Autoextend, even on System, has caused no problems that I'm aware of.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715
JApplewhite_at_austin.isd.tenet.edu

                                                                                            
                    Sam Bootsma                                                             
                    <SamB_at_cpas.com       To:     Multiple recipients of list ORACLE-L       


                    >                     <ORACLE-L_at_fatcity.com>                            

                    Sent by:             cc:                                                
                    root_at_fatcity.c       Subject:     System Tablespace and Autoextend      
                    om                                                                      
                                                                                            
                                                                                            
                    10/24/2002                                                              
                    01:26 PM                                                                
                    Please respond                                                          
                    to ORACLE-L

Hello All,

I have heard several times that if the SYSTEM tablespace runs out of space and needs to autoextend (assuming autoextend is turned on for the data file), then you run the risk of the database crashing and of data dictionary
corruption. I have never personally encountered this problem, so I have no experience on what actually does happen.

I looked in metalink for documents on this, but turned up nothing. Does anybody have experience on the dangers of allowing the SYSTEM tablespace to autoextend and also any documents on Metalink or OTN that describe this problem?

We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2. All our Oracle
versions are running on Windows NT (or Windows 2000).

Thanks for any feedback.

Sam Bootsma, OCP
samb_at_cpas.com

--
Author: Sam Bootsma
  INET: SamB_at_cpas.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: JApplewhite_at_austin.isd.tenet.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Thu Oct 24 2002 - 15:14:37 CDT