OBJECT_CACHE_OPTIMAL_SIZE
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.
| Property | Description |
|---|---|
| Parameter type | Integer |
| Default value | 51200000 (50M) |
| Modifiable | ALTER SESSION, ALTER SYSTEM ... DEFERRED |
| Modifiable in a PDB | Yes |
| 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. On the server, it is used to cache frequently used objects requested as a result of client requests to help in performance.
See Also: ProC/C++ Developer’s Guide](/pls/topic/lookup?ctx=en/database/oracle/oracle-database/26/refrn&id=LNPCC4321) and [Oracle Call Interface Developer’s Guide* for information on precompiler use of the object cache