Re: DB_BLOCK_BUFFERS question

From: James Dickson <James.Dickson_at_mail.esrin.esa.it>
Date: Wed, 03 Feb 1999 21:39:49 +0100
Message-ID: <36B8B415.205D@mail.esrin.esa.it>

Kai Horstmann wrote:
>
> Michael L. Mason schrieb:
> > Max. number of DB_BLOCK_BUFFERS is 3200. Is this
> > correct?
>
> No, Allocate as much as your memory controller allows.
> But: do you really need as much memory for block buffers (1GB)?

To calculate the optimum value for DB_BLOCK_BUFFERS use the table SYS.X$KCBRBH as described in the Server Tuning manual. Beyond the optimum value, adding more buffers just consumes memory without improving performance.

James
--
james_at_valhall.esrin.esa.it.NOSPAM Received on Wed Feb 03 1999 - 14:39:49 CST