Tuesday, 8 September 2009

Performance Tuning - Question 061.

When determining the optimal configuration for dispatchers by querying the V$DISPATCHER_RATE view, which of the following is not true?

A . If the CUR_ column values are near their AVG_ counterparts and below the MAX_ values, and response time is good, then you probably have a good number of dispatchers allocated.

B . If, under system load, you see that CUR_ is close to or equal to MAX_, then consider increasing the number of dispatchers.

C. If, under system load, you see that CUR_ is close to or equal to MAX_, then consider decreasing the number of dispatchers.

D . If CUR_ and AVG_ are consistently well below MAX_, then consider reducing the number of dispatchers.

Explanation:

Answer C: Each of the other answers is an approach you could use to tune the number of dispatchers. The basic concept that if your dispatcher load is close to MAX_, then you should consider adding more dispatchers.

No comments:

Post a Comment