Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

OBJECT_CACHE_OPTIMAL_SIZE

Parameter type

Integer

Default value

102400 (100K)

Parameter class

Dynamic: 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:

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