OBJECT_CACHE_OPTIMAL_SIZE


Property Description

Parameter type

Integer

Default value

102400 (100K)

Modifiable

ALTER SESSION, ALTER SYSTEM ... DEFERRED

Range of values

10 KB to operating system-dependent maximum

Basic

No


The object cache is a memory block on the client that allows applications to store entire objects and to navigate among them without round trips to the server. OBJECT_CACHE_OPTIMAL_SIZE specifies (in bytes) the size to which the session object cache is reduced when the size of the cache exceeds the maximum size.

See Also:

Pro*C/C++ Programmer's Guide and Oracle Call Interface Programmer's Guide for information on precompiler use of the object cache