Re: shared_pool_size=800M ???

On Wed, 18 Feb 2004 21:12:44 +0100, Marc Blum <blumNOSPAM_at_marcblum.de> 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
>

Not using bind variables I guess. However, if you don't use bind variables you can set the shared pool to anything and it will be exhausted.
You could of course also use
select * from v$sgastat
to see how much free memory is in the various pools

--
Sybrand Bakker, Senior Oracle DBA