B make the redo log buffer at least as large as the

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: 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. Answer: A Explanation: The main redo log buffer tuning goal is to avoid space waits situations in the redo log buffer. Incorrect Answers: B: The redo log buffer does not need to be at least as large as the buffer cache, it will decrease performance only. 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 QUESTION 62: 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. Answer: B Explanation: After issue the ALTER TABLE ... DEALLOCATE UNUSED command all blocks above the high-water mark of table will be deallocated. Incorrect Answers: 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 QUESTION 63: The database is set up to run Multithreaded Server. Which...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online