Temp tablespace at 100%
854290Apr 11 2011 — edited Apr 12 2011Good Morning,
My temp tablespace is full , that is bad for the database performance? It is used for do sorts and group by and and nobody reports my any problem.
Database Freespace Summary
Tablespace Size (MB) Free (MB) % Free % Used
------------------------------ ---------- ---------- ---------- ----------
TEMP1_TS 3000 0 0 100
TEMP 25421 0 0 100
It's a production database , Can I add another datafile o do another task without a shutdown?
It's bad have this tablespace full?
Regards.