That was the first check I did. And all my temp tablespaces are of "TEMPORARY" type only. I did lot of reasearch on metalink and I found there are some issues with 8.1.7 in this regard. I got this suggestion from metalink only.
-----Original Message----- Sent: Thursday, January 16, 2003 4:52 PM To: Multiple recipients of list ORACLE-L If your temp tablespace is set up as temporary, you don't want to 'clean it up'. The point of a temp tablespace is to reuse existing, but inactive, blocks in the sort segment. -----Original Message----- [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 2:15 PM To: Multiple recipients of list ORACLE-L I do have my pctfree set to 0 for all my tablespaces. But I observe my temp ts filled up at times and continue to be in that status even if I don't have any active transactions using the temp. I wake up the SMON by issuing the following to do the cleanup. And I have 8.1.7 running. alter tablespace temp default storage (pctincrease 0) Thanks, Suren -----Original Message----- Sent: Wednesday, January 15, 2003 7:55 AM To: Multiple recipients of list ORACLE-L we have ORACLE 8.1.7 on NT server and this erver only run ORACLE application. Sometime the server will have 100% CPU usage form 20 minutes to couple hours. In that time No one can login or do anything. We guess the problem come from SMON, but all of the tablespaces pct_increase is 0 (except SYSTEM). The only thing I can guess is SMON clean the Temporary Tablespace (our temporary tablespace define as dicrionary Temporary temporary tablespace). Does their has way to reduce or avoid this problem? Thanks. _________________________________________________________________ The new MSN 8 is here: Try it free* for 2 months http://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fink, Dan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
