The syntax for assigning an object to a buffer pool

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: o different buffer pools. The syntax for assigning an object to a buffer pool is STORAGE (BUFER_POOL POOL), where POOL can be set to KEEP, RECYCLE, or DEFAULT, depending on which buffer pool you want blocks from this object to be part of. Incorrect Answers: A: The KEEP buffer pool can be deferred or can not be if the RECYCLE pool is defined. B: The buffer pool for an object can be set with CREATE OBJECT or ALTER OBJECT command, it means the buffer pool can be set not only at object creation time. C: The blocks from an object without an explicitly set buffer pool go into the DEFAULT pool, not the RECYCLE pool. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 867-870. Chapter 18: Tuning Memory and Operating System Use Actualtests.com - The Power of Knowing 1Z0-024 QUESTION 24: What should one be your tuning goals? A. Use as much memory as possible. B. Use multiple copies of the code in memory. C. Access the most possible number of blocks from disk. D. Access the least possible number of blocks from disk. Answer: D Explanation: One of tuning goals is access the least possible number of blocks from disk to avoid I/O contention. Incorrect Answers: A: One of tuning goals can be usage as less, not as much memory as possible. B: To improve performance you need to try to use the same SQL code to avoid multiple copies of the code in memory. C: One of tuning goals is access the least, not the most possible number of blocks from disk to avoid I/O contention. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 892-904. Chapter 19: Tuning Disk utilization QUESTION 25: When should you recommend changing the applications in orderto reuse more SQL? A. When the GETHITRATIO in the V$LIBRARYCACHE view is above 0.99 B. When the misses in the dictionary cache are greater than 1% of the hits. C. When the ratio of GETHITS to GETS in the V$LIBRARYCACHE view is less than 0.9 D. When the ratio of RELOADS to PINS in the V$LIBRARYCACHE view is less than 0.01 Answer: C Explanation: You need to tune your application to reuse more SQL if the ratio of GETHITS to GETS in the V$LIBRARYCAC...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online