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

From: dist cash <mccdba_at_hotmail.com>
Date: Wed, 15 Jan 2003 04:55:10 -0800
Message-ID: <F001.00530264.20030115045510@fatcity.com>

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

Received on Wed Jan 15 2003 - 06:55:10 CST