Statement Cache Size Not Configurable
Last updated on JUNE 28, 2017
Applies to:Oracle WebLogic Server - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 12c]
Information in this document applies to any platform.
IBM AIX on POWER Systems (64-bit) 7.2
Oracle WebLogic Server 126.96.36.199.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