Integer 

Dynamic. Scope = ALTER SESSION, ALTER SYSTEM ...DEFERRED. 

10 

0 to operating system dependent maximum 

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_MAX_SIZE_PERCENT specifies the percentage of the optimal cache size that the session object cache can grow past the optimal size. The maximum size is equal to the optimal size plus the product of this percentage and the optimal size. When the cache size exceeds this maximum size, the system will attempt to shrink the cache to the optimal size.

See Also:

• "OBJECT_CACHE_OPTIMAL_SIZE" for a description of the object cache.

• Oracle8i Concepts, Pro*C/C++ Precompiler Programmer's Guide, and Oracle Call Interface Programmer's Guide for information on precompiler use of the object cache.