Applies To
OraDatabase
Description
Sets the optimal size for the client-side object cache in bytes. The default
value is 200k bytes.
Usage
Oradatbase.CacheOptimalSizeoptimalsize
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
Oracle9i server. This is property is useful for performance tuning for accessing
Oracle9i object instance.
Datatype
Long
