My Oracle Support Banner

Statement Cache Size Not Configurable (Doc ID 2277575.1)

Last updated on SEPTEMBER 17, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.