| 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: help!! smon
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
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
 |
 |