Re: db block buffers

From: Martin Rapier <M.Rapier_at_shef.ac.uk>
Date: 26 Aug 1998 15:40:38 GMT
Message-ID: <6s1a9m$psq$2@bignews.shef.ac.uk>

In article <6s049q$68t$1_at_sloth.swcp.com>, elufker_at_swcp.com says...
>
>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???

As with all things, it depends. How much memory is on your server, how much is left over for use by the OS and user processes? It is no good having a huge database cache if the OS is paging like crazy as there are only a few Mb of real memory left for users.

IMHO follow the DB tuning guide, increase your cache incrementally until you are getting a decent hit ratio (95% or better). The rule of thumb used to be cache approx 1% of your physical DB size, but it depends on access patterns etc.

Cheers
Martin.

--
Martin Rapier, Database Administrator
Corporate Information & Computing Services. University of Sheffield Tel 0114 222 1137 The opinions expressed here may be those of my employer, or they may not. http://rhino.shef.ac.uk:3001/mr-home/ Received on Wed Aug 26 1998 - 10:40:38 CDT