Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: shared_pool_size=800M ???

Re: shared_pool_size=800M ???

From: DJ <nospamplease_at_goaway.com>
Date: Wed, 18 Feb 2004 20:30:27 -0000
Message-ID: <GXPYb.1037$1h7.8651@newsfep4-glfd.server.ntli.net>

"Marc Blum" <blumNOSPAM_at_marcblum.de> wrote in message news:nah730d7metm3ce03ua1rh21l3m2hgp55p_at_4ax.com...
> 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

simple answer - it doesnt way to big and will probably cause you problems cos I bet they arent using binds in their java code.

Ask them why they think it should be 800M Received on Wed Feb 18 2004 - 14:30:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US