Home » RDBMS Server » Server Administration » SYSTEM Tablespace "Full" (sles 8, oracle 9i)
SYSTEM Tablespace "Full" [message #360240] Thu, 20 November 2008 02:55 Go to next message
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
Member
The SYSTEM tablespace on one of my servers is very small, but it sits in a filesystem that is busy running out of space.

Question: Is it ok to just add a second datafile to the SYSTEM tablespace, in another filesystem, and set that one to autoextend ?


I just want to make sure there aren't any hidden surprises waiting for me, seeing that this is on the SYSTEM tablespace.

(ie. the management of the system tablespace is the same as any other tablespace ?)


Dirk
Re: SYSTEM Tablespace "Full" [message #360245 is a reply to message #360240] Thu, 20 November 2008 03:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is it ok to just add a second datafile to the SYSTEM tablespace, in another filesystem,

It is OK.
Quote:
set that one to autoextend ?

Better follow the tablespace free space and add a new file or manually extend the current one when needed rather than risking an out of space in the file system which will corrupt the file and your database.

Regards
Michel
Re: SYSTEM Tablespace "Full" [message #360254 is a reply to message #360240] Thu, 20 November 2008 03:51 Go to previous messageGo to next message
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
Member
Great, thank you Michel - much appreciated

Dirk
Re: SYSTEM Tablespace "Full" [message #360259 is a reply to message #360240] Thu, 20 November 2008 03:59 Go to previous messageGo to next message
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
Member
PS. you mentioned corruption of the file and the database.

Is this what will happen when the system tablespace gets full ? I was under the impression that Oracle will either hang or shut down, not being able to continue - but not that the space will get corrupted.


Dirk
Re: SYSTEM Tablespace "Full" [message #360276 is a reply to message #360259] Thu, 20 November 2008 04:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is this what will happen when the system tablespace gets full ?

AND it tries to autextend AND the file system is full.

Regards
Michel
Re: SYSTEM Tablespace "Full" [message #360286 is a reply to message #360240] Thu, 20 November 2008 05:03 Go to previous message
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
Member
Thank you Michel
Previous Topic: Install fails: primary interface must be configured with a static IP
Next Topic: Oracle 9i
Goto Forum:
  


Current Time: Fri Dec 09 21:43:21 CST 2016

Total time taken to generate the page: 0.07941 seconds