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!

Temp tablespace - why so big?

Red Hand LukeOct 6 2008 — edited Oct 7 2008

Temp tablespace (size 6gb) is twice the size of my data and index tablespace combined. I am running into space issues and am wondering is it possible to resize this tablespace and/or take some other action to prevent the temp tablespace getting so relatively large?

Thanks in advance.

This post has been answered by Anand... on Oct 6 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2008

Added on Oct 6 2008

#cache, #general-database-discussions

13 comments

2,947 views