Marc Blum wrote:
>
> 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
800m will never work...Its needs to be 717m.
:-)
--
-------------------------------
Connor McDonald
http://www.oracledba.co.uk
Co-Author: "Mastering Oracle PL/SQL - Practical Solutions"
Received on Thu Feb 19 2004 - 07:48:43 CST
