** temp tablespace

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Thu, 23 Oct 2003 11:49:34 -0800
Message-ID: <F001.005D41F9.20031023114934@fatcity.com>

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
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: A Joshi
  INET: ajoshi977_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Oct 23 2003 - 14:49:34 CDT