Where best to cache the disk
From: Paul Beardsell <psb_at_sambusys.demon.co.uk>
Date: Mon, 31 Oct 1994 11:53:22 +0000
Message-ID: <783604402snz_at_sambusys.demon.co.uk>
Date: Mon, 31 Oct 1994 11:53:22 +0000
Message-ID: <783604402snz_at_sambusys.demon.co.uk>
We are not using raw partitions for our tablespaces. Are we better off caching inside Oracle by using a large SGA and a small Unix disk cache or should we use a small SGA and a large Unix disk cache?
I am tempted to assign all our spare memory to the Unix disk cache (by increasing NBUF etc) and to keep the SGA just big enough for DC_* dictionary caching.
What say you?
-- Paul Beardsell SAM Business Systems Ltd ~~~~~~~~~~~~~~ 21 Finn House, Bevenden St, pbeardsell_at_cix.compulink.co.uk London, N1-6BN, UK. psb_at_sambusys.demon.co.uk (+44 or 0)71 608-2391Received on Mon Oct 31 1994 - 12:53:22 CET