A gets b sleeps c misses d immediategets e immediate

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: A. GETS B. SLEEPS C. MISSES D. IMMEDIATE_GETS E. IMMEDIATE_ MISSES F. IMMEDIATE_GETS Answer: A Explanation: If a willing-to-wait latch request is satisfied on the first attempt, GET statistics will be increased. GETS column in V$LATCH view is the number of latch requests that resulted in actually obtaining the latch. Incorrect Answers: B: SLEEPS column shows the number of times a process waited for the latch, and then requested to obtain it again. C: MISSES column shows the number of latch requests that did not result in actually obtaining latch. D: It is the number of latch requests that resulted in immediately obtaining the latch. E: IMMEDIATE_MISSES is the number of latch requests that were unsuccessful in obtaining the latch. F: Copy of D. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 953-955 Chapter 20: Tuning Other Areas of the Oracle Database QUESTION 8: Actualtests.com - The Power of Knowing 1Z0-024 For which reason would you query V$SYSSTAT? A. Name of the sort segment. B. Free space available for a sort segment. C. Number of disk sorts performed since startup. D. Number of users active on individual sort segments. Answer: C Explanation: To determine buffer-cache hits, the DBA can use the V$SYSSTAT dynamic performance view to calculate the buffer-cache hit ratio. The hit ratio is determine by the total number of instance data requests (the sum of the two "get" statistics) minus physical reads, divided by the total number of instance data requests, multiplied by 100. Incorrect Answers: A: The V$SYSSTAT view does not show the name of the sort segment. B: TheV$SYSSTAT is not used for free space of the sort segment information. D: The V$SYSSTAT view does not show the number of users active on individual sort segments. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 861-863 Chapter 18: Tuning Memory and Operating System Use QUESTION 9: Which two statements about plan stability and stored outlines are true? (Choose two) A. You can group outlines in cat...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online