Re: Tuning questions (may be stupid)

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/11/19
Message-ID: <3472EF53.702A7C81@gatwick.geco-prakla.slb.com>#1/1

cmcantie_at_utmb.edu wrote:

> Okay, these are probably stupid questions but I am trying to figure out how
> everything fits together here. If my total sga is 10,842,420 bytes that means
> that this particular Oracle database is taking up 10Mb of operating system
> memory, right? I want to increase db_block_buffers because the hit ratio is
> 74%. How do I know how much additional memory each buffer I add will take?
>
> Thanks.

Each additional db_block_buffer will increase the size of the SGA by the value of db_block_size.

Regards,

Ian Received on Wed Nov 19 1997 - 00:00:00 CST