RE: ** temp tablespace

From: <Stephen.Lee_at_DTAG.Com>
Date: Thu, 23 Oct 2003 13:34:40 -0800
Message-ID: <F001.005D4217.20031023133440@fatcity.com>

4GB isn't all that huge.
A couple of questions I can think of are:

1. How many users are simultaneously trying to sort stuff?
2. How often does some dufus fire up a Cartesian join?

-----Original Message-----

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

--

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

Author: <Stephen.Lee_at_DTAG.Com
  INET: Stephen.Lee_at_DTAG.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 - 16:34:40 CDT