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!

temp01.dbf size increased drammatically

goodluck247Sep 27 2017 — edited Oct 16 2017

Hello all,

We have 10.2.0.1.0 installed, and recently we encountered the following problem:

the file /temp01.dbf has grown much larger in size, close to 6GB, within an hour, it also (at least we think so) caused our server to crash.

Normally, the size of this file was 600-700 MB. We believe it slows down the server performance.

What should we do about this? Can we delete this temp file, and create another one? Is it safe to manipulate this file?

Thank you.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 13 2017
Added on Sep 27 2017
8 comments
3,760 views