View the Exhibit and identify the component marked with a question mark. ()
A.Checkpoint (CKPT) B.Process Monitor (PMON) C.Archiver Processes (ARCn) D.Recoverer Process (RECO) E.Memory Manager process (MMAN)
Note the functionalities of various background processes: 1:Perform recovery at instance startup. SMON 2:Free the resources used by a user process when it fails. PMON 3:Cleanup the database buffer cache when a process fails. PMON 4:Dynamically register database services with listeners. PMON 5:Monitor sessions for idle session timeout. PMON 6:Cleanup unused temporary segments. SMON 7:Record the checkpoint information in control file. CKPT Which option has the correct functionalities listed for a background process()
A.Checkpoint (CKPT): 1, 2, 5 B.System Monitor (SMON): 1, 6 C.Process Monitor (PMON): 4, 6, 7 D.Database Writer (DBWR): 1, 3, 4
Note the following functionalities of various background processes: 1:Record the checkpoint information in data file headers. CKPT 2:Perform recovery at instance startup. SMON 3:Cleanup unused temporary segments. SMON 4:Free the resources used by a user process when it fails. 5:Dynamically register database services with listeners. 6:Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process()
A.Archiver Process (ARCn):1, 2,5 B.System Monitor Process (SMON):1,4,5 C.Process Monitor Process (PMON):4,5,6 D.Database Writer Process (DBWn):1,3,4