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
>>> [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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).
