Yep, CE
PMON periodically performs cleanup of all the following:
Processes that died abnormally
Sessions that were killed
Detached transactions that have exceeded their idle timeout
Detached network connections which have exceeded their idle timeout
In addition, PMON monitors, spawns, and stops the following as needed:
Dispatcher and shared server processes
Job queue processes
Pooled server processes for database resident connection pooling
Restartable background processes
https://docs.oracle.com/database/121/REFRN/GUID-86184690-5531-405F-AA05-BB935F57B76D.htm#REFRN104
Which two statements about the Process Monitor (PMON) process are true?
A. PMON performs process recovery when a client process fails.
B. During instance startup, PMON takes care of instance recovery.
C. PMON performs listener registration.
D. PMON restarts background and dispatcher processes when they fail.
E. PMON resolves failures of distributed transactions.
Answer: AD
PMON is responsible for cleaning up the database buffer cache and freeing resources that the client process was using. For example, PMON resets the status of the active transaction table, releases locks that are no longer required, and removes the process ID from the list of active processes.
D and E are correct. Since database version is not mentione din question, the option D is valid. Prior to 12c, PMON registers database to Listener services.
PMON does not kill process, but cleans up resources after a process is killed. "The PMON group oversees cleanup of the buffer cache and the release of resources used by a client process."
So C is not correct.
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cncpt/process-architecture.html#GUID-B5CA9579-53DB-442C-A85F-F21FD334833A
It seems I am wrong. Confused between the workd cleanup and kill. Document https://docs.oracle.com/database/121/REFRN/GUID-86184690-5531-405F-AA05-BB935F57B76D.htm#REFRN104
states:
PMON periodically performs cleanup of all the following:
Detached transactions that have exceeded their idle timeout
Detached network connections which have exceeded their idle timeout
So, I'm not sure if that means kills a session or not.
Also, since question states version as 12c (I missed that :/), so PMON does not register database to listener, LREG does. So, D is incorrect.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
sherifelia
Highly Voted 5 years agoLazyLH
4 years, 7 months agokhan
Highly Voted 5 years, 8 months agoHavok
4 years, 10 months agoluizyto
Most Recent 1 year, 11 months agoRay520
2 years, 8 months agoRay520
2 years, 8 months agoOracle2020
3 years, 4 months agoMohit201920
4 years, 9 months agoSugar
5 years, 1 month ago