Oracle-L: Re: ** temp tablespace

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Fri, 24 Oct 2003 04:36:09 -0800
Message-ID: <F001.005D4351.20031024043609@fatcity.com>

Hi!

How much free space you have in your file system, you might be hitting the sparse files issue...

Tanel.

Original Message ----- From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Thursday, October 23, 2003 10:49 PM Subject: ** temp tablespace

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: Tanel Poder
INET: tanel.poder.003_at_mail.ee

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 Fri Oct 24 2003 - 07:36:09 CDT