OraFAQ Forum: Server Administration » SYSTEM Tablespace "Full"

Home » RDBMS Server » Server Administration » SYSTEM Tablespace "Full" (sles 8, oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SYSTEM Tablespace "Full" [message #360240]

Thu, 20 November 2008 02:55

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

Report message to a moderator

Re: SYSTEM Tablespace "Full" [message #360245 is a reply to message #360240]

Thu, 20 November 2008 03:22

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: SYSTEM Tablespace "Full" [message #360254 is a reply to message #360240]

Thu, 20 November 2008 03:51

dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa

Member

Great, thank you Michel - much appreciated

Dirk

Report message to a moderator

Re: SYSTEM Tablespace "Full" [message #360259 is a reply to message #360240]

Thu, 20 November 2008 03:59

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

Report message to a moderator