469,951 Members | 2,450 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,951 developers. It's quick & easy.

system tablespace

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
Jul 19 '05 #1
1 6024
gecho <ge***@hawaii.rr.com> wrote in message news:<pa****************************@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


Gecho, by extending the system tablespace manually you eliminated the
additional overhead that would have occurred when Oracle attempted to
expand an object and then discovered that the file space necessary to
hold the extent did not exist but could be obtained by expanding the
file. Depending on what operation would have taken the extent that
resulted in the file auto-extending this overhead may or may not have
been noticable to the end user. But taking it early did not hurt and
may have prevented a performance hit.

IMHO -- Mark D Powell --
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Hari Om | last post: by
6 posts views Thread by gimme_this_gimme_that | last post: by
1 post views Thread by Sam Durai | last post: by
1 post views Thread by gecho | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.