Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> TEMP Tablespace not clearing

TEMP Tablespace not clearing

From: <cemail_at_sprintmail.com>
Date: Thu, 12 Oct 2000 14:13:48 -0700
Message-Id: <10647.119113@fatcity.com>


When we run a process in the database, the Temp tablespace fills up. Looking at OEM Storage Manager, shouldn't the Amount Used decrease back down to zero after the process has been finished and committed when there isn't anything else running on the database?  Ours doesn't seem to clear out. Does temp clear out when the table being sorted is no longer being sorted or is there some other DB process that comes along periodically and cleans it out?



Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! Received on Thu Oct 12 2000 - 16:13:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US