Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: writes dirty buffers from the buffer cache to the data files. Answer: E Explanation: SMON is Oracle background process, which handles instance recovery after database startup if necessary, and periodically coalesces smaller chunks of free space in tablespaces into larger chunks. The main function of SMON in instance recovery is to roll forward transactions applying changes in the redo log files. Also a function of SMON in Oracle8 is to deallocate space in temporary segments no longer in use. Incorrect Answers: A: SMON does not write data anywhere itself, ARCH process writes data to the archive log files. B: SMON does not write data anywhere itself, LGWR process writes data changes into redo log files. C: PMON process frees resources held by user processes, not SMON. D: CKPT process synchronizes data file header and control file. F: DBWR background process writes dirty buffers from the buffer cache to the datafiles. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 565 Chapter 12: Overview of Backup and Recovery QUESTION 15: What is the function of ARCn in instance recovery? A. It...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online