Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

System tablespace is 99% full

Neo-bApr 11 2012 — edited Apr 12 2012

hello all,

I created a new Oracle 11gR2 11.2.0.3.

i am checking the Oracle Enterprise manager, i saw the my system tablespace size is 700 M and it is 99% full.

Do i have to re size system tablespace datafile?
does that affect my database, do i have to restart it ?
99% full of system table space will affect my database performance?
How can I specify the best size of my system tablespace?

Regards,

This post has been answered by CKPT on Apr 11 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2012

Added on Apr 11 2012

#general-database-discussions

15 comments

45,278 views