471,108 Members | 1,302 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

SYSTEM Tablespace is FULL

I am using Oracle 9.2.0.1 on IBM AIX 5.1L
My following Tablespaces are 99% full....is it normal...? do I need to
increase manually or is ti done automatically:
---------------------------------------------------------
TABLESPACE SIZE USED %USED
---------------------------------------------------------
SYSTEM 400MB 394MB 98
EXAMPLE 138MB 137MB 99
XDB 38MB 37MB 99
---------------------------------------------------------

Do you think increasing the above Tablespace will increase the speed
also?

Any related informaiton is appreciated.

(Apologize for my ignorance)
THANKS!
Jul 19 '05 #1
2 14057
no problem
it will automatically increase
Jul 19 '05 #2
ku***********@hotmail.com (KULJEET) wrote in message news:<fe**************************@posting.google. com>...
no problem
it will automatically increase


Before expanding the SYSTEM tablespace you should find out what is
using it! If the list of tablespaces your listed is complete then you
need to add a temporary segment (sort) tablespace and a Rollback
Segment (rbs) tablespace unless the two other tablespaces shown server
these purposes.

The Concepts manual has a decent chapter on physical/logical database
setup.

If you are missing a temp segment TS then after creating one:
alter user username temporary tablespace temp [or whatever name you
give it, but temp or tmp are the most traditional names] for every
user other than SYS.

HTH -- Mark D Powell --
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by airmax | last post: by
3 posts views Thread by Troels Arvin | last post: by
2 posts views Thread by Hari Om | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.