Re: DB_BLOCK_BUFFERS under NT

From: MotoX <rat_at_tat.a-tat.com>
Date: Thu, 24 Sep 1998 08:10:15 +0100
Message-ID: <906620917.15734.0.nnrp-05.c2de712e@news.demon.co.uk>

But *always* monitor the *OS* as well. You can get great hit ratio's on the SGA with virtual memory, and very poor performance due to all the swapping. Oracle is not an island.

MotoX.

PMIS wrote in message <01bde75b$ee9934a0$5065a3a8_at_pmaaumisws5124.au.pmi>...
>The larger the data block buffer cache is, the more memory is available for
>sharing data already in memory, reducing the need for physical reads.
>Monitor the database hit ratio to determine if you can increase
>db_block_buffers.
>
>
>Regards
>zdenka
>
>Greg Deuel <gdeuel_at_frxsoft.com> wrote in article
><kP9O1.11$ub2.107145_at_client.news.psi.net>...
>> A basic question. Is there a limit to the number of db_block_buffers
>that
>> can be assigned under NT 4.0 with either Oracle 7.3.x or 8.x?
>>
>> Thanks,
>>
>> - Greg
>>
>> Greg Deuel
>> gdeuel_at_frxsoft.com
>>
>>
>>
Received on Thu Sep 24 1998 - 02:10:15 CDT