Oracle System Architecture Question:
Download Job Interview Questions and Answers PDF
Tell me what are the functions of SMON?
Answer:
System Monitor (SMON) performs instance recovery at instance start-up. In a multiple instance system (one that uses the Parallel Server), SMON of one instance can also perform instance recovery for other instance that have failed SMON also cleans up temporary segments that are no longer in use and recovers dead transactions skipped during crash and instance recovery because of file-read or off-line errors. These transactions are eventually recovered by SMON when the tablespace or file is brought back on-line SMON also coalesces free extents within the database to make free space contiguous and easier to allocate.
Download System Architecture Interview Questions And Answers
PDF
Previous Question | Next Question |
What is the approach taken by Oracle to pass ACID test of a database transaction? | Explain what constitute an ORACLE Instance? |