| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] SMON take too much time to clean up?
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:Surendra.Tirumala_at_mail.state.ky.us]
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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: dist cash
INET: mccdba_at_hotmail.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).
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).
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 Jan 16 2003 - 15:51:58 CST
 |
 |