D the uga components may not reside in the buffer

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: it is called the PGA, or Program Global Area. D: The UGA components may not reside in the buffer cache by definition. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 858-859. Chapter 18: Tuning Memory and Operating System Use QUESTION 68: Summing the system statistics, (db block gets + consistent gets) gives the total number of requests. What is the other system, statistic required to calculate the buffer cache hit ratio? A. Physical reads. B. Session logical reads. C. Table scan blocks gotten. D. DBWR buffers scanned. Answer: A Explanation: To calculate the buffer cache hit ration you need also to know physical reads. Formula for calculation is: 1- physical reads / (db_block gets + consistent gets). Incorrect Answers: B: Session logical reads statistic is not required to calculate the buffer cache hit ratio. C: Table scan blocks gotten statistic is not used to calculate the buffer cache hit ratio. D: DBWR buffer scans statistic is not required for this purpose also. Actualtests.com - The Power of Knowing 1Z0-024 Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 859-863. Chapter 18: Tuning Memory and Operating System Use QUESTION 69: Which statement about the LOG_BUFFER initialization parameter is true? A. The LOG_BUFFER parameter can be changed dynamically. B. The minimum value for the LOG_BUFFER parameter is 512KB. C. The LOG_BUFFER parameter value must be a multiple of the database block size. D. The LOG_BUFFER parameter value must be a multiple of the operating system lock size. Answer: C Explanation: The LOG_BUFFER parameter value must be a multiple of the database block size, DB_BLOCK_SIZE parameter. Incorrect Answers: A: The LOG_BUFFER parameter cannot be changed dynamically. You can edit this parameter, but it will be changed only after instance restart. B: The minimum value for the LOG_BUFFER parameter is not 512 KB, it can be less. D: The LOG_BUFFER parameter value must be a multiple of the database block size, not operating system block size. QUESTION 70: You determined that the values for REQUEST_FAILURES as seen from V$SHARED_POOL_RESE...
View Full Document

Ask a homework question - tutors are online