This preview shows page 1. Sign up to view the full content.
Unformatted text preview: void space waits situations in the redo log buffer.
B. Make the redo log buffer at least as
large as the buffer cache.
C. Mirror redo log files and store group members on different disks.
D. Make sure that the LGWR process is faster than the database writer processes.
The main redo log buffer tuning goal is to avoid space waits situations in the redo log buffer.
B: The redo log buffer does not need to be at least as large as the buffer cache, it will decrease
C: Redo log files need to be mirrored and different members of groups need to be stored on
different disks, but this is not main redo log buffer tuning goal.
D: There is not so close correlation between the LGWR process and the database writer process.
The LGWR process can work slower than the DBWR.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 873-876.
Chapter 18: Tuning Memory and Operating System Use
You need some extra space in your database, so you issue the ALTER TABLE my_table
DEALLOCATE UNUSED command. What happens?
A. All empty blocks of MY_TABLE are deallocated.
B. All blocks above the high-water mark of
MY_TABLE are deallocated.
C. All blocks below the high-water mark of MY_TABLE are deallocated.
D. The high-water mark of MY_TABLE is recalculated and stored in the segment header.
After issue the ALTER TABLE ... DEALLOCATE UNUSED command all blocks above the
high-water mark of table will be deallocated.
A: All blocks, including empty ones, below the high-water mark of table will still be in use.
C: All blocks below the high-water mark of table will still be in use.
D: You can reset the high-water mark of table with TRUNCATE command, but not with
ALTER TABLE. Actualtests.com - The Power of Knowing 1Z0-024
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 918-921.
Chapter 19: Tuning Disk Utilization
The database is set up to run Multithreaded Server. Which...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09