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

On Fri, 14 Jun 2002 18:35:31 GMT, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:

>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

The original poster is running Winblows. You are comparing apples and pears. The overhead of Winblows is enormous.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jun 15 2002 - 00:08:10 CDT