Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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:

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