Statement Cache Size Not Configurable
Last updated on JUNE 28, 2017
Applies to:Oracle WebLogic Server - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 12c]
Information in this document applies to any platform.
IBM AIX on POWER Systems (64-bit) 7.2
Oracle WebLogic Server 220.127.116.11.0
The Statement Cache Size parameter is not configurable on a datasource when using oracle.jdbc.replay.OracleDataSourceImpl driver.
Tuning or adjusting the Statement Cache Size parameter to 25 from default 0, and activating changes does not work, the default value 0 is returning in the Console. Changing the value directly in the jdbc.xml file has no effect; when adjusted and restarting the admin server and datasource, the Statement Cache Size still reads 0.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms