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

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:

Note:

1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘OBJECT_CACHE_OPTIMAL_SIZE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
object_cache_optimal_size	102400	TRUE	TRUE	DEFERRED	TRUE	FALSE	optimal size of the user session's object cache in bytes

Oracle initializatoin parameters