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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: help!! smon

Re: help!! smon

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Mon, 07 Oct 2002 05:18:30 -0800
Message-ID: <F001.004E20E9.20021007051830@fatcity.com>


Alex,
 If you were performing a long running function such as creating an index and lost you connection to the database then the index would reach the end of creation, find that you were not connected and completely undo the process. The indexes are created in a "TEMPORARY" segment before they are made perminent in the datafile. SMON has the job of cleaning up the segments that were used during the index creation. You can check the dba_extents table to see what is being cleaned up. If the number of extents on any segment is decreasing then SMON is doing work on that segment. It should give you an idea what is going on in the database.
 Some of the actions that SMON performs continues from where it left off when the database is shutdown and restarted. Other action will restart from the beginning and continue until completion. The description in the backup and recover handbook gives a fair idea of what is happening with SMON.
 I know that this answer is a little late but it could help in the future.
Ron
ROR m¬┐¬m

>>> aordonez_at_ccss.sa.cr 10/04/02 04:44PM >>>
Hi gurus ,,,
i need check what do you doing the smon proc!!! this process have 99% of CPU!!!!
somebody help me!!!

@lex



  Lic. Alexander Ordˇ˝ez Arroyo
  Soporte Tru64Unix & BD Oracle
  Caja Costarricense del Seguro Social                             
  Telefono: 295-2004, San JosÚ, Costa Rica                    
  Aordonez_at_ccss.sa.cr      Celular 397-0532

------------------------------------------------------------ 
The truth is out there in WWW
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Alexander Ordonez
  INET: aordonez_at_ccss.sa.cr 

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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 Mon Oct 07 2002 - 08:18:30 CDT

Original text of this message

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