Unformatted text preview: s not the same as the data dictionary cache.
B: Recursive SQL are stored in the library cache, not in the data dictionary cache.
D: An object can be pinned in the shared pool with the DBMS_SHARED_POOL. It does not
matter whether this object have been in the shared pool or not.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 852-854.
Chapter 18: Tuning Memory and Operating System Use
Which action could result in less frequent checkpoints?
A. Increasing the number of redo log groups.
B. Increasing the value of DB_BLOCK_SIZE
C. Decreasing the value of the REDO_LOG_BUFFERS parameter.
D. Increasing the value of the FAST_START_IO_TARGET parameter. Actualtests.com - The Power of Knowing 1Z0-024
The frequency of checkpoints will be decreased if the value of the FAST_START_IO_TARGET
will be increased: Oracle will need more time to recover database after instance crash.
A: The number of redo log groups has no relation with frequency of checkpoints.
B: DB_BLOCK_SIZE buffer has nothing to do with checkpoints.
D: By decreasing the value of the REDO_LOG_BUFFERS you will INCREASE frequency of
checkpoints because redo log files will be filled with updates more quickly.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 902.
Chapter 19: Tuning Database Utilization
Which two statements about database blocks are true? (Choose two)
A. OLTP environments prefer a large block size
B. Small block size results in more block
C. Sequential access to large amounts of data favors a large block size
D. You can reduce the number of block visits by packaging rows as closely as possible into
E. To change the database block size, you must shut down the instance and perform a STARTUP
RESETLOGS after you make the change.
Answer: C, D
The key feature of a decision support system is fast sequential access to large amounts of data, so
DSS environment prefer a large database block size. Also remember that you can reduce the
number of block visits by packing rows as closely as possible into blocks, so Oracle will need
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09