An administrator has deployed an application that uses 30 unique SQL statements with a maximum data source connection pool size of 10. What is the recommended prepared statement cache size for the…

The correct answer is B. 30. To determine the highest value for your cache size to avoid any cache discards, add the number of uniquely prepared statements and callable statements, as determined by the SQL string, concurrency, and the scroll type, for each application that uses this data source on a…

Performance Monitoring and Tuning

Question

An administrator has deployed an application that uses 30 unique SQL statements with a maximum data source connection pool size of 10. What is the recommended prepared statement cache size for the application?

Options

A10
B30
C40
D300

How the community answered

(58 responses)

A
12% (7)
B
78% (45)
C
3% (2)
D
7% (4)

Explanation

To determine the highest value for your cache size to avoid any cache discards, add the number of uniquely prepared statements and callable statements, as determined by the SQL string, concurrency, and the scroll type, for each application that uses this data source on a particular server. This value is the maximum number of possible statements that can be cached on a given connection over the life of the server. Setting the cache size to this value means that you never have cache discards. In general, configure a larger cache for applications with a greater number

Topics

#prepared statement cache#data source#connection pool#database tuning

Community Discussion

No community discussion yet for this question.

Full C9510-418 Practice