This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ill not write changes to the next online redo log group. Oracle instance will fail.
C: Oracle instance will not hang, like it does when there is no space for archived log files, it will
D: Restarting of archive process ARCH will not help in this situation, because instance will fail.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 330-332
Chapter 7: Managing the Physical Database Structure
A data block is put on the free list when the _____ data space in the block falls _____ the
A. Free, below, PCTFREE
B. Free, above, PCTFREE
C. Used, below, PCTUSED
D. Used, above, PCTUSED
Answer C is correct. When the used data space in the block falls below the PCTUSED setting, a
data block is put on the free list of blocks and can be used for new inserts.
A: When the free data space in the block falls below the PCTFREE settings a data block will be
out of the free list.
B: The free data space in the block cannot fall above the PCTFREE setting, it can fall just below
D: The used data space in th...
View Full Document
- Fall '09