SQL & PL/SQL

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 full.

CodebreakerOct 17 2016 — edited Oct 17 2016

Hi all,

My TEMP tablespace keeps running out of space. A few weeks back I got this issue where TEMP tablespace was full.

I shrank the space and it was all normal but now I am facing the same issue again where my TEMP tablespace has reached an alarming 97%

and even after executing "alter tablespace TEMP shrink space;" nothing seems to happen.

I know to recreate the TEMP tablespace again will probably solve the issue but I don't want to do it since its a Production Environment.

I even added a tempfile to TEMP tablespace "alter tablespace TEMP add tempfile '+DATA_PRDB/codexsdb/tempfile/temp.333.dbf' size 1800M;"

and I can see it listed also but still the used percentage remains 97% .

Any suggestions how can I troubleshoot this would be appreciated .

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 14 2016

Added on Oct 17 2016

11 comments

1,534 views