Concepts and Architecture Question:
Download Job Interview Questions and Answers PDF
How does the SMON process performs recovery after instance failure?
Answer:
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
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
Download Oracle Architecture and Concepts Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is high watermark in oracle? | Explain what is the back ground process in oracle architecture? |