What are the functions of SMON?

Answers were Sorted based on User's Feedback



What are the functions of SMON?..

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

What are the functions of SMON?..

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

What are the functions of SMON?..

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

What are the functions of SMON?..

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

What are the functions of SMON?..

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

What are the functions of SMON?..

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

What are the functions of SMON?..

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

Post New Answer

More Oracle Architecture Interview Questions

What is advantage of having disk shadowing/ Mirroring ?

1 Answers  


List the Optional Flexible Architecture (OFA) of Oracle database ?

1 Answers  


What are the functions of SMON?

7 Answers  


How will you monitor rollback segment status ?

2 Answers  


What is the role of PCTFREE parameter is Storage clause ?

2 Answers  






How to define Data Block size in Oracle?

0 Answers  


How will you monitor the space allocation ?

3 Answers  


what is ORACLE MEMORY STRUCTURES

3 Answers  


How the log writer writes the data into database

4 Answers   Baidu, Satyam,


What is Database Buffers ?

4 Answers  


Name the ORACLE Background Process?

3 Answers  


What is an oracle database schema?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)