Experience with OBJECT_CACHE_OPTIMAL_SIZE?
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.