Note the following functionalities of various background processes: 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary…

Question

Options

• AArchiver Process (ARCn): 1, 2, 5
• BSystem Monitor Process (SMON): 1, 4, 5
• CProcess Monitor Process (PMON): 4, 5, 6
• DDatabase Writer Process (DBWn): 1, 3, 4

• A
  8% (3)
• B
  3% (1)
• C
  74% (29)
• D
  15% (6)

Explanation

The Process Monitor Process (PMON) is responsible for: (4) freeing resources held by a failed user process (cleaning up the cache and releasing locks), (5) dynamically registering database services with the listener (a role that in newer Oracle versions is shared with LREG, but traditionally attributed to PMON), and (6) monitoring sessions for idle session timeout and enforcing resource limits. The other options are incorrect because: ARCn only archives filled redo log groups - it does not record checkpoint info (that's CKPT), perform recovery (that's SMON), or register services. SMON performs instance recovery at startup (2) and cleans up unused temporary segments (3), not the functions listed in option B. DBWn writes dirty buffers from the buffer cache to data files - it does not record checkpoint headers (CKPT does), clean temp segments, or free user process resources.

No community discussion yet for this question.