关于这个参数的说明：

Statement caching improves performance by caching executable statements that are used repeatedly, such as in a loop or in a method that is called repeatedly. Starting from JDBC 3.0, JDBC standards define a statement-caching interface.

Statement caching can do the following:

*   Prevent the overhead of repeated cursor creation   *   Prevent repeated statement parsing and creation   *   Reuse data structures in the client这次应用端做了参数调整，应用把只从30改到15，DB的这些指标明显上升：

soft prase，

table scan(short tables),

logons,

bytes receive via sql*net from client

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/668365/viewspace-1037856/，如需转载，请注明出处，否则将追究法律责任。