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

Home -> Community -> Usenet -> c.d.o.server -> SMON eating 90% CPU

SMON eating 90% CPU

From: Hermann Maier <benutzer_at_beispiel.at>
Date: Thu, 11 Mar 2004 13:28:56 GMT
Message-ID: <8454178bbdbd31a15f8e3d9f100e167c@news.teranews.com>


I have the problem that after restart of my database (8.0.5.1.0 on Solaris) SMON is doing something with my TEMP tablespace since 15 hours. I read something about coalescing extents and so on, so I created a new tablespace (not temporary) and defined the new tablespace as the temporary tablespace for all users.
I also used dbms_system.set_ev to set the event 10061 to stop SMON doing the cleanup of temporary segments.
My question: None of the actions helped. My apps are damn slow, sometimes I see that SMON is blocking other sessions. What can I do to stop SMON cleaning up temporary segments? Do I have to shutdown, startup w/o opening and drop the old temp tablespace? And why is SMON doing this only after restart of database? During normal work, I never see SMON cleaning up temp segments.

Thank you in advance,

Hermann

P.S. I know that we are using a _very_ old version of Oracle but our apps are fixed to 8.0 Received on Thu Mar 11 2004 - 07:28:56 CST

Original text of this message

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