Hi,

  I have a huge  temp tablespace (4GB) and not much usage (current usage is 50MB  from v$ tables) . However it keeps running out of space. It ran out of space yesterday and I was hoping it would release but it got an error again. The database is only 35GB mostly small tables. IT is temporary (contents). How can i tell how much is *actually* free. dba_free_space shows hardly any free even when there is no activity. Thanks


Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

Reply via email to