This preview shows page 1. Sign up to view the full content.
Unformatted text preview: writes dirty buffers from the buffer cache to the data files.
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.
A: SMON does not write data anywhere itself, ARCH process writes data to the archive
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
What is the function of ARCn in instance recovery?
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09