Re: Tuning questions (may be stupid)

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.

Memory required for block buffer: DB_BLOCK_BUFFERS * DB_BLOCK_SIZE bytes To see what is the DB_BLOCK_SIZE use server manager (svrmgrl on UNIX): SVRMGR> show parameter db_block_size

-- 

Timo Haatainen
Carelcomp Forest Oy