调整prepare statement cache size对数据库的影响，简单的说这个statement cache设置在应用端，缓存了应用到数据库的一些sql。[@more@]
关于这个参数的说明：
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博客 ” ，链接：https://blog.itpub.net/668365/viewspace-1037856/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
加数据文件引起load上升
请登录后发表评论
登录
全部评论
