Link to home
Start Free TrialLog in
Avatar of asotoh
asotoh

asked on

TABLESPACE TEMP FULL

HI guys

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.

 


 
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial