From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.tools Subject: Re: How big should shared pool size be for WEBDB ???? Date: Sat, 11 Nov 2000 15:00:05 +0100 Message-ID: <973951573.22512.3.pluto.d4ee154e@news.demon.nl> References: <3a0c0ff3@news.wau.nl> NNTP-Posting-Host: sybrandb.demon.nl X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78 X-Trace: news.demon.nl 973951573 pluto:22512 NO-IDENT sybrandb.demon.nl:212.238.21.78 X-Complaints-To: abuse@nl.demon.net X-Newsreader: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 Lines: 28 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" wrote in message news:3a0c0ff3@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@pve.agro.nl > >