| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
| 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 | 
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:
Oracle Database Concepts, Pro*C/C++ Programmer's Guide, and Oracle Call Interface Programmer's Guide for information on precompiler use of the object cache