IBM
C2180-317 · Question #17
While monitoring a JDBC data source's performance during a test load, a system administrator notices that there are a large number of prepared statements discarded from the cache. In order to…
The correct answer is A. Increase the size of the prepared statement cache until there are no statement discards under load. See the full explanation below for the reasoning.
Question
While monitoring a JDBC data source's performance during a test load, a system administrator notices that there are a large number of prepared statements discarded from the cache. In order to improve application throughput, how should the administrator tune the data source?
Options
- AIncrease the size of the prepared statement cache until there are no statement discards under load.
- BIncrease the maximum connection pool size and keep the prepared statement cache at its default size.
- CSet the connection pool purge policy to "EntirePool" and increase the maximum connection pool size.
- DSet the minimum connection pool size equal to the maximum connection pool size and keep the prepared
How the community answered
(36 responses)- A81% (29)
- B11% (4)
- C3% (1)
- D6% (2)
Community Discussion
No community discussion yet for this question.