Home » RDBMS Server » Server Administration » Why cant the SYSTEM tablespace extend? (RDBMS 10.2.0.3, HPUX)
Why cant the SYSTEM tablespace extend? [message #448102] Fri, 19 March 2010 08:27 Go to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

The SYSTEM tablespace refuses to autoextend (3 segments in SYSTEM tablespace unable to extend). It sits on its current size of 559MB (auto set to 2GB, increment 10M).

I guess there are no free extends that are that big as 10M.

But how do I solve this?

Regards
H
Re: Why cant the SYSTEM tablespace extend? [message #448105 is a reply to message #448102] Fri, 19 March 2010 08:34 Go to previous messageGo to next message
joy_division
Messages: 4616
Registered: February 2005
Location: East Coast USA
Senior Member
First we would have to ask what object is it that is trying to extend? I hope it is not a user created object as nothing should be put in the SYSTEM tablespace.

And yes, you do not have a 10Mb contiguous chunk.
Re: Why cant the SYSTEM tablespace extend? [message #448106 is a reply to message #448102] Fri, 19 March 2010 08:38 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

This are the objects: INDEX SYS.PK_C0, INDEX SYS.PK_CT, INDEX SYS.PK_CS

So its seems its not a user that have messed up.

Regards
H
Re: Why cant the SYSTEM tablespace extend? [message #448108 is a reply to message #448106] Fri, 19 March 2010 08:44 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What are table names that those indexes belong to? Are those tables meant to be created in SYS schema?
Re: Why cant the SYSTEM tablespace extend? [message #448110 is a reply to message #448108] Fri, 19 March 2010 08:53 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
They belong to the following tables:

SYS.PK_C0 = DBMS_UPG_CAT_C0$
SYS.PK_CT = DBMS_UPG_CAT_CT$
SYS.PK_C0 = DBMS_UPG_CAT_CS$

Regards
H
Re: Why cant the SYSTEM tablespace extend? [message #448120 is a reply to message #448102] Fri, 19 March 2010 10:46 Go to previous message
hristo
Messages: 258
Registered: May 2007
Senior Member
I turned off autoextend and resized the datafile, the error is gone. I guess Oracle needs enough space on disc (which it did not have) for ALL the autoextend before extending (in this case 2GB).

Regards
H
Previous Topic: OS_CPU_WAIT_TIME AND PHYSICAL_MEMORY_BYTE
Next Topic: What Oracle EE options are in use - License compliance
Goto Forum:
  


Current Time: Tue Sep 27 09:17:46 CDT 2016

Total time taken to generate the page: 0.16606 seconds