CacheOptimalSize Property

Applies To

Description

Sets the optimal size for the client-side object cache in bytes. The default value is 200k bytes.

Usage

Oradatbase.CacheOptimalSize optimalsize

Remarks

This parameter increases the client side object cache size. If the memory occupied by the objects currently in the cache exceeds the high water mark ( maximum object cache size), then the cache automatically begins to free unmarked objects which have a pin count of zero. The cache continues freeing such objects until memory usage in the cache reaches the optimal size, or until it runs out of objects eligible for freeing. This parameter should be set to appropriate value so that object cache can accommodate all the fetched object instance from Oracle Database 10g. This is property is useful for performance tuning for accessing an Oracle Database 10g object instance.

Datatype

Long