A library cache b dictionary cache c entire shared

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: columns of V$ROWCACHE to determine the hit ratio for? A. Library cache. B. Dictionary cache. C. Entire shared pool. D. Large objects such as PL/SQL packages. Answer: B Explanation: The V$ROWCACHE view statistics is used to tune dictionary cache. You calculate the hit ratio using the formula : sum (GETS - GETMISSES) / sum (GETS) * 100. An ideal hit ratio for dictionary-cache activity is 99 percent or higher. Incorrect Answers: Actualtests.com - The Power of Knowing 1Z0-024 A: The V$ROWCACHE view is not used to tune the library cache. The V$LIBRARYCACHE view is used for this purpose. C: With V$ROWCACHE you can tune only data dictionary cache, not entire shared pool cache. D: This view is not used to determine the hit ratio for large objects such as PL/SQL packages. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 852-858. Chapter 18: Tuning Memory and Operating System Use QUESTION 83: You pinned an object in the shared pool using the DBMS_SHARED_POOL package. Which command could you use to unpin this object, assuming you are in a SQL*Plus session? A. ALTER SYSTEM FLUSH SHARED_POOL; B. EXECUTE dbms_shared_pool.unping; C. EXECUTE dbms_shared_pool.unkeep; D. EXECUTE dbms_library_cache.unpin; Answer: C Explanation: To unpin this object you need to use "EXECUTE dbms_shared_pool.unkeep" command. Incorrect Answers: A: This command just will flush the shared pool: all space in the shared pool is then freed temporarily for new statements to parse, which temporarily reduces performance for other statements running on the system. B: There is no UNPING procedure or function in dbms_shared_pool package. D: There is no dbms_library_cache package in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 855-857. Chapter 18: Tuning Memory and Operating System Use QUESTION 84: Which two parameters could result in problems when starting more shared servers? (Choose two) A. PROCESSES B. MTS_MAX_SERVERS C. MTS_MAX_PROCESSES D. MTS_MAX_DISPATCHERS E. PARALLEL_MAX_SERVERS Answer: A, B Explanation: There are two parameters in initialization par...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online