Integer 

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

102400 (100 KB) 

10 KB 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_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: 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.