⟩ How does the SMON process performs recovery after instance failure?
When hardware failure, software failue and shutdown abnormally happen...
SMON taking care of Instance failure, coalesce failure space and deallocating temp segment
start to recover instance Roll fwd with help of redologfiles for commited transaction and roll backward upto uncommited
transaction with help of undotablespace.
coalesce failure space: De-fragmenting every 3 sec
deallocating temp segment: Sorting purpose