Oracle Database Discussions

Hi Experts,

First temp use:

TABLESPACE_NAME                                                                            Tot Size (GB)  used (GB)     % used     % free

------------------------------------------------------------------------------------------      -------------      ----------          ---------- ----------

TEMP1                                                                                                      15                    9                   63         37

then it reached to 99.9%

After that I have restarted the DB and checked the temp space.

Then found the same, 99.9%.

It is not releasing anyway.. while no job running also temp uses is same always.

Please help to resolve the issue.

Thanks

Vivek