Re: How big should shared pool size be for WEBDB ????

Hi Peter,

IIRC the minimum is 60M. On other that, if you only have 128M physical RAM in that server, you are working with a too large SGA, which will result in paging and faulting on O/S level. Oracle's guideline is to use no more than 25 to 33 percent of physical memory for the complete SGA, so db_block_buffers, shared_pool_size and log_buffers. You are aware 7.3.4 will be desupported soon?

Hth,

Sybrand Bakker, Oracle DBA

"Peter" <p.c.de.wolff_at_zonnet.nl> wrote in message news:3a0c0ff3_at_news.wau.nl...
> We have a WEBDB site up and running but it is not very fast.
> Toad is telling my shared pool size is too small but it is almost 50Mb (of
> 128MB memory)
>
> We are running oracle 7.3.4 on a Alpha 1000 running VMS
> Webdb is on a NT box
>
> P.c.de.wolff_at_pve.agro.nl
>
>
Received on Sat Nov 11 2000 - 15:00:05 CET