Home » RDBMS Server » Server Administration » Localy managed temporary tablespace
Localy managed temporary tablespace [message #56497] Thu, 03 April 2003 15:07 Go to next message
Snezana
Messages: 1
Registered: April 2003
Junior Member
Hi,
I have a problem with my temporary tablespace (localy managed).Although it is very large (13G), it is getting full very fast, for just few days, and I don't know how to clean it up. The sole manner is to shutdown the database. I try to switch it to dictionary managed one and that use the little trick with the default storage, but it was not working because the tablespace system was localy mannaged too.
Does anybody know how I can solve my problem?

Thanks!

Snezana
Re: Localy managed temporary tablespace [message #56623 is a reply to message #56497] Sat, 12 April 2003 02:42 Go to previous message
Muhammad Waqas Shabir
Messages: 26
Registered: April 2003
Junior Member
Hi!
This is database design fault! It is recommended that your userdata and index should be on separate hard disk or controller or machine. this will improve your database performance to a great extent.

Goodluck!
Previous Topic: DBA related help need.
Next Topic: Clients not connecting to server
Goto Forum:
  


Current Time: Sun Dec 29 13:44:45 CST 2024