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!

Temporary tablespace growing very fast.

JerinMay 22 2014 — edited Jun 3 2014

Dear All,

I am using 10g Enterprise Edition Database, last two to treeĀ  weeks temporary tablespace growing very fast, like within two days its grow more than 30GB. Now its almost 120GB size for temporary tablespace itself.

My question is why temporary tablespace growing like this way?

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2014
Added on May 22 2014
7 comments
5,121 views