Re: db block buffers

From: Keith Boulton <boulke_at_globalnet.co.nospamuk>
Date: Wed, 26 Aug 1998 17:04:41 GMT
Message-ID: <35e438cd.36118155@news.globalnet.co.uk>

On 26 Aug 1998 04:52:10 GMT, elufker_at_swcp.com (Ed Lufker) wrote:

>Hi All:
>
> Does anyone see anything wrong with having db block buffer set to
>1.4G. What are the performanace issues. Should the database fly or is this
>too big???
>

The oracle 8 performance tuning manual states that this can be a problem in some environments because of the time taken to map the sga onto a server process's memory space (dynamic address translation table entries must be built). during login and that a larger value for memory page size should be specified for the OS if possible. Received on Wed Aug 26 1998 - 12:04:41 CDT