1Z0-024

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: DBA Certification Exam Guide, Jason S. Couchman, p. 754-759 Chapter 16: Introducing Database Tuning QUESTION 54: To control fragmentation of your shared pool space, when is the best time for you to pin objects with the DBMS_SHARED_POOL package? A. Immediately after instance startup. B. After an object has been used for the first time. C. When the V$LIBRARYCACHE view contains higher values in the RELOADS column than in the PINS column. D. When the sum of values in the SHARABLE_MEMORY column of the V$DB_OBJECT_CACHE view exceeds the value of the SHARED_POOL_SIZE initialization parameter. Answer: A Explanation: It's better to pin objects with the DBMS_SHARED_POOL package to control fragmentation of your shared pool space immediately after instance startup. Incorrect Answers: B: If an object has been used for the first time, it's in shared pool already, you don't need load it with DBMS_SHARED_POOL package. May be it have been unloaded already because of heavy usage of shared pool and you will need to load it again, but this can cause shared pool space fragmentation. C: When the V$LIBRARYCACHE view contains higher values in the RELOADS column than in the PINS column, you need increase you shared pool size first to avoid additional physical reads from the disk. After that you can restart instance and pin the object into the shared pool. D: If values in the SHAREBLE_MEMORY column of the V$DB_OBJECT_CACHE view exceeds the value of the SHARED_POOL_SIZE initialization parameter, you will not be able to pin this object into shared pool, because there is not enough space for it in shared pool. You need increase SHARED_POOL_SIZE parameter, restart the instance and pin the object into the shared pool. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 855-857. Chapter 18: Tuning Memory and Operating System Use QUESTION 55: Which type of change to an application is most likely to improve the performance of the library cache? A. Adding more frequent COMMIT statements. B. R...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online