Interested to Buy Any Domain ? << Click Here >> for more details...
What are the functions of SMON?
- 7 Answers
- 20206 Views
- I also Faced
- E-Mail Answers
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 |
How free extents are managed in Ver 6.0 and Ver 7.0 ?
Can a View based on another View in Oracle?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
• What is oracle Architecture?
What is Cursor?
What do Redo Log Buffers contain?
What Does DBWR do?
What is a Control file ?
How will you monitor rollback segment status ?
What are the consideration at tehe migration of Oracle 9i to 10G.
When Does DBWR write to the database?
What is advantage of having disk shadowing/ Mirroring ?
Oracle General 
