Database Administration (MOSC)

MOSC Banner

Experience with OBJECT_CACHE_OPTIMAL_SIZE?

edited Nov 26, 2009 11:09PM in Database Administration (MOSC) 2 commentsAnswered
 Hi all,

   I was wondering if any of you have any experience in the use of this initialisation parameter?  What sort of objects are stored locally for the session, e.g. is it just code or are tables, indexes etc. also stored?  Are you aware of any 'gotchas' that I'd need to be aware of, e.g. memory issues on the client(s), contention etc.

   The reason I'm looking at this parameter is that we have a 3rd party app that sits on an application server between the users and our database server.  The app fires sql across to the database and they're complaining of poor response times (3+ seconds in some cases, when they're expecting tenths or even hundredths of seconds).  Running the code on the database server gives the sort of response times they require so it looks like it's the intermediate network traffic that is the delay and this parameter looks like it may be of use in reducing this.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center