In most cases, the DBA can tune latches and minimize latch contention by configuring which latch parameters?
A . DB_LATCH_COUNT
B . Setting DB_LATCH_CONTENTION=SAFE
C . Setting DB_LATCH_MONITORING=AUTO
D. The DBA doesn't tune latches; instead, the DBA tunes the processes that contribute to latch contention.
E . By setting the values for individual problem latches in the init.ora file.
Explanation:
Answer D: In Oracle9i, there are no parameters that directly tune latches. Latch contention is evidence that some other application code or database parameter needs to be tuned. Hidden parameters (_*) can be used to configured some latches, but they are usually unsupported unless you have been specifically instructed to use them by Oracle Support.
No comments:
Post a Comment