Re: Setting init.ora parameters when running more than one DB on one machine

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 14 Jun 2002 18:35:31 GMT
Message-ID: <3d0a3726.783236083@news.globix.com>

On Thu, 13 Jun 2002 19:00:37 +0200, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

>
>25% and 50% is clearly *outrageous*. Oracle recommends one third for
>*SGA*. Have you ever checked the page fault rate of that server? It
>must be choking!!!!
>If you have 7G RAM Oracle recommends devoting one third to all the
>SGA's together, so in this case about 2G.
>If you need more, you may question whether the applications you have
>were ever tuned. Most of today's developers don't know how to do that.

Actually, I think I want to argue a little against this.. If you disable file buffering you can probably use up to 70% of RAM. I haven't noticed any problems when I did that. .......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Jun 14 2002 - 13:35:31 CDT