This preview shows page 1. Sign up to view the full content.
Unformatted text preview: A. GETS
E. IMMEDIATE_ MISSES
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.
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
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
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.
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.
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
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 861-863
Chapter 18: Tuning Memory and Operating System Use
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.
- Fall '09