MaxStatementCacheSize

This property specifies the maximum number of statements that can be cached on a particular OracleConnection object when self-tuning is enabled.

Declaration

// C#
public int MaxStatementCacheSize { get; set;}

Property Type

System.Int32

Exceptions

InvalidArgument - The specified value is less than 0 or greater than System.Int32.MaxValue .

System.ObjectDisposedException - This property cannot be accessed after the OracleConnection object is already disposed.

Remarks

The default value is 100.

The MaxStatementCacheSize property can be configured on OracleConnection and OracleConfiguration objects. By default, OracleConnection MaxStatementCacheSize property value inherits OracleConfiguration MaxStatementCacheSize property value at construction time. The value of OracleConnection MaxStatementCacheSize will be used during the connection.

See Also:

• "Oracle.DataAccess.Client and Oracle.ManagedDataAccess.Client Namespaces"

• OracleConnection Class

• OracleConnection Members

• Self-Tuning Statement Caching