What are the functions of SMON?
Answers were Sorted based on User's Feedback
Answer / ankur aggarwal
smon is background process in a sga.
its name is system monitor.function is monitering the system
its used for database recovery when database is crash.
Is This Answer Correct ? | 15 Yes | 7 No |
Answer / mahe
SMON will trigger the instance recovery. Internally DBWR
writes the committed data to the datafile after the roll
forward. SMON will do rollback and rollforward not writing
to the datafiles.
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / praveen
1. SMON Will take care of Instance & Crash Recovery
2. SMON Will perform Roll Forward from Online Redolog Files
and bring the database to open status and perform Roll
Backward which bring back the uncommitted changes from Undo.
3. SMON Also clear all the temp segments
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / r.karthikeyan
The System Monitor (SMON) background process performs instance recovery, coalesces adjacent areas of free space in the datafiles, and deallocates temporary segments to return them as free space in the data files. When instance recovery is required, SMON rolls forward changes in the redo logs, opens the database for user access, and rolls back uncommitted transactions.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vikas singh
SMON is system monitor. It is used for opening the database
and instances. If system/computer is shunt down abortly
then it(SMON) also start the instance recovery.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sreddy1987
When Database terminated abnormally and when we restart the instance System Monitor(SMON) performs "crash recovery". While doing the crash recovery SMON rollbacks all the transactions which are not committed and roll forwards the committed transactions and invokes the db writer to write the data into database.
When user performs sorting, if sorting takes place in temporary table space that will be cleaned by SMON once the user activity done.
The adjacent free extents join into one single large extent.
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / pravin pardeshi
smon is used for rolling forward the committed data and
rolling back the rollback data.smon writes commited data
from log buffer to data files.
Is This Answer Correct ? | 9 Yes | 17 No |
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
Name the ORACLE Background Process?
How does Space allocation table place within a block ?
What is an Integrity Constrains in Oracle?
How the space utilisation takes place within rollback segments?
what is ORACLE MEMORY STRUCTURES
What are the uses of Oracle Rollback Segment?
What is function of RECO?
What is an Oracle Data Block?
What is Cursor?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What is the maximum number of Lock Processes used?