shared_pool_size=800M ???

9.2.0.4 EE, SUN Solaris

At a customer's site I installed a database/instance for a new app. All I knew was, that there wouldn't be much code running in the db, perhaps some plsql and a bit of java. The vast majority of work would be done by the clients, written in java by some OO-fellows. I gave the instance 100m shared pool which is pretty much, but to be on the safe side.

Now the developers start complaining, the shared pool ought to have 800m !!! I myself doesn't have any clue why any app needs so much shared pool. So please enlighten me with some serious reasons for that.

thanks in advance  

--
Marc Blum
mailto:blumNOSPAM_at_marcblum.de
http://www.marcblum.de