Re: Tuning questions (may be stupid)

From: Steve Adams <steveadams_at_acslink.net.au>
Date: 1997/11/18
Message-ID: <3470d736.955101888@newsserver.trl.oz.au>#1/1

For every buffer added there is obviously an increase of db_block_size for the buffer itself. But less commonly mentioned is the corresponding increase in the variable portion of the SGA for a buffer header (176 bytes in version 7.3). There is also an extra hash chain header (8 bytes) and latch (112 bytes) for every four extra buffers (approximately - assuming _db_block_hash_buckets has been allowed to default).

Regards,
Steve Adams
steveadams_at_acslink.net.au

---

On 17 Nov 1997 16:23:04 GMT, 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?
>
Received on Tue Nov 18 1997 - 00:00:00 CST