Hello friends,
I am working on an OLTP 10.2.0.5 database on HP-UX 11.23 and trying to understand how to tune the OBJECT_CACHE_OPTIMAL_SIZE.
I've searched this site, as well as MetaLink without much luck.
I wonder if someone here can help...
The default value for OBJECT_CACHE_OPTIMAL_SIZE is 102400. It is dynamic, but it is deferred.
From what I've found on this subject:
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.
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. Without using the application to
test this, it serves no purpose to test in SQL*Plus.
Has anyone any experience with tuning this parameter?
Thx.
ji li