Statement Cache Size Not Configurable (Doc ID 2277575.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle WebLogic Server - Version 12.2.1.2.0 to 12.2.1.2.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

IBM AIX on POWER Systems (64-bit) 7.2
Oracle WebLogic Server 12.2.1.2.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.

Cause

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