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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Why my Temporary tablespace is always 99% full ?

Re: Why my Temporary tablespace is always 99% full ?

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Mon, 12 May 2003 10:18:16 -0500
Message-ID: <alevbvouscj1fkfcc7n9f39qdbrbjsp0uc@4ax.com>


"Redd" <javatek?@usa.com> wrote:

>Maybe you should increase the size of the Temp tablespace.
A Temporary Tablespace ( A true TEMPORARY type one) will show that it is that full..This is normal behavior and is not a problem.
The space is actually available for use - it is reused by objects, etc that need it.. hth,

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Mon May 12 2003 - 10:18:16 CDT

Original text of this message

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