Which two statements are true about the (PMON) background process in Oracle Database 12c?
A.
It records checkpoint information in the control file.
B.
It frees unused temporary segments.
C.
It kills sessions that exceed idle time.
D.
It registers database services with all local and remote listeners known to the database instance.
E.
It frees resources held by abnormally terminated processes.
Explanation:
https://docs.oracle.com/database/122/CNCPT/process-architecture.htm#CNCPT9840
I think CE
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cncpt/process-architecture.html#GUID-CFD15DE0-4CB6-4D22-BDA3-5EA48C9DC6A2
not A – CKPT
not B – SMON
C – done by CLMN on behalf of PMON
not D – since 12c – LREG
E for sure.
C-
PMON delegates cleanup work to the cleanup main process (CLMN). The task of detecting abnormal termination remains with PMON.
CLMN periodically performs cleanup of terminated processes, terminated sessions, transactions, network connections, idle sessions, detached transactions, and detached network connections that have exceeded their idle timeout.
This question popped up on my exam with LREG instead of PMON in the question. If that is the case for the question you get as well, the answer remains D, E.