Which two actions would be appropriate choose two a

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: RVED is more than zero and always increasing. Which two actions would be appropriate? (Choose two) A. Decrease the value for LARGE_POOL_SIZE parameter. B. Increase the value for LARGE_POOL_SIZE parameter. C. Increase the value for SHARED_POOL_SIZE parameter. D. Decrease the value for SHARED_POOL_SIZE parameter. E. Increase the value for SHARED_POOL_RESERVED_SIZE parameter. F. Decrease the value for SHARED_POOL_RESERVED_SIZE parameter. Answer: C, E Explanation: The V$SHARED_POOL_RESERVED dynamic performance view is designed to assist in tuning shared-pool reserved-list configuration. An important column is REQUEST_FAILURES, indicating the number of shared pool space requests that weren't granted. If value for this column is always increasing, you should increase SHARED_POOL_SIZE and SHARED_POOL_RESERVED_SIZE. Actualtests.com - The Power of Knowing 1Z0-024 Incorrect Answers: A: The LARGE_POOL_SIZE parameter is not related with V$SHARED_POOL_RESERVED view. B: The LARGE_POOL_SIZE parameter is not related with V$SHARED_POOL_RESERVED view. D: You should increase, not decrease the SHARED_POOL_SIZE parameter. F: You should increase, not decrease the SHARED_POOL_RESERVED_SIZE parameter. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 857-858. Chapter 18: Tuning Memory and Operating System Use QUESTION 71: Why can you NEVER achieve a value of zero in the GETMISSES column of V$ROWCACHE? A. The database buffer cache can never be empty. B. Recursive SQL has to be reparsed each time it is used. C. Object definitions must be loaded into the shared pool following instance startup. D. An object cannot be pinned in the shared pool with the DBMS_SHARED_POOL package until it has been at least once. Answer: C Explanation: It's NEVER possible to achieve a zero value in the GETMISSES column of V$ROWCACHE view because at least some object definitions must be loaded from the data dictionary into the shared pool immediately after instance startup. Incorrect Answers: A: The database buffer cache i...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online