I have a temporary tablespace with 26 GB size, i think that is to much. The problem is that this table has been full for 4 or 5 months.
I have some questions about it.
1.- Can I delete the content from this tablespace to get a empty tablespace?
2.- Why has this tablespace been full for 5 months?
3.- Does this issue generate that the database performance is low?
4.- What can i do know who is using al this space?
i ran a query to know who is using this space but didn´t get any row.
SQL> select * from v$sort_usage;
no rows selected
Thanks for all your coments.