- Process Monitor process is background process that periodically scans all processes to find any that have died abnormally. Pmon is then responsible for coordinating cleanup performed by the cleanup main process (CLMN) and the cleanup Slave Process slaves (CLnn).
- Monitors the other background processes and performs process recovery when a server or dispatcher process terminates abnormally
- PMON constantly checks the status of user and database processes. In some cases, failed database processes can be restarted by PMON.
- Once instance is started , PMON registers information about the instance to the network listener.
- From Oracle 12c, PMON also registered database services with the listener. This is now handled by the new LREG progress.
- PMON normally wakes up every 3 seconds to perform its housekeeping activities. PMON must always be running for an instance
- PMON process is killed then instance will shutdown.
- If user process fails,PMON cleans up the database buffer cache and release the resources that the user process was using. It also resets the status of the active transaction table, release locks, and removes the process ID from the list of active processes.
Which two statements are true about the PMON background process? (Choose two.)
- A. It registers database services with all local and remote listeners known to the database instance
- B. It frees resources held by abnormally terminated processes
- C. It records checkpoint information in the control file
- D. It frees unused temporary segments
- E. It kills sessions that exceed idle time