Skip to Main Content

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!

TEMPFILE GROWS TO 128GB in WINDOWS PLATFORM

user12104101Sep 24 2013 — edited Sep 26 2013

Hi All,

I am working on 11.2.0.3.0 on windows server 2008 paltform.

My tempfile grows to 128GB and now it imacting database performace as this is the max size in windows platform for one DBF.

Should I need to add another datafile or change the default tablespace.

What will be the best approach?

Thanks is advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2013
Added on Sep 24 2013
14 comments
901 views