What are the functions of SMON ?

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.

Interview Candidate
Sep 6th, 2004
9
5950

System Architecture

Answer

Showing Answers 1 - 9 of 9 Answers

msabuu

Nov 6th, 2007

If server unplanned shutdown, Power failure SMON Instant recovery. there is two type of Instant recovery 1st is Roll forward 2nd Roll back.
Rollback means committed transaction.
Rollforward means uncommitted transaction.

msabuu
Profile Answers by msabuu

Nov 6th, 2007

If server unplanned shutdown, Power failiure SMON Instant recovery. there is two type of Instant recovery 1st is Roll forward 2nd Roll back.
Rollback means comitted transaction.
Rollforward means uncommitted transaction.