db_cache_size, granules and large amount of physical memory
Date: Thu, 6 Aug 2009 11:16:34 +0200
I am working with several Sun M9000 servers, it looks like that db_cache_size has quite large default values (even set to a low value) when the server has a large amount of physical memory.
server 1 has 16 quadcore Sparc 960MHz with threading on so it shows 128 CPU,
with 512GB physicla memory
server 2 has 4 quadcore Sparc 960MHz with threading on so it shows 32 CPU, with 128GB physicla memory
When db_cache_size is manually set to 64MB in server 1 it actually uses 512MB and server 2 128MB.
Is there anyway to decrease this default limit?
http://www.freelists.org/webpage/oracle-l Received on Thu Aug 06 2009 - 04:16:34 CDT