[Q] SMON take too much time to clean up?

[dist cash]

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).