system tablespace

From: gecho <gecho_at_hawaii.rr.com>
Date: Sat, 10 Jul 2004 02:32:01 GMT
Message-Id: <pan.2004.07.10.02.27.33.733470@hawaii.rr.com>

New to oracle, but I'm coming from the sybase side.

I took over one of our oracle production databases (1.5 Tb) while the regular dba is out. I got errors (unable to extend temp segment) for two user tablespaces which I took care of by adding a datafile to each. While reviewing the other tablespaces, I was surprised to see the system tablespace at 99%. I checked with app folks. No new objects were added accidentally to it. I panicked and resized the system tablespace by an additional 33%. Upon review, I forgot to notice that the system tablespace was set to autoextend. My question is this: even with the autoextend option set, is there a performance hit or crash potential by not resizing the system (or any other) tablespace before it hits 100%? On the sybase side, I take care of the logical devices before it reaches 85%.

~newbie appreciates any comments
thanks,
gecho Received on Fri Jul 09 2004 - 21:32:01 CDT