Oracle Database 12c: Installation and Administration — Question 115
Which two are true about the SMON background process? (Choose two.)
Answer options
- A. It performs instance recovery, if required, at instance startup.
- B. It monitors sessions for idle time out.
- C. It performs process recovery for user process failures.
- D. It deletes orphaned temporary segments in permanent tablespaces.
- E. It monitors the status of dispatchers and server processes.
Correct answer: B, E
Explanation
The SMON background process is responsible for monitoring sessions for idle timeouts and checking the status of dispatchers and server processes, which are indicated by options B and E. Options A, C, and D do not accurately describe SMON's functions, as instance recovery is typically handled by the database instance startup process, and process recovery is not within SMON's responsibilities.