DSS System -- db_cache_size and pga_aggregate_target
From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sun, 20 Jul 2008 12:34:19 +0800
Message-Id: <200807200434.m6K4YT0m004106@smtp14.singnet.com.sg>
Date: Sun, 20 Jul 2008 12:34:19 +0800
Message-Id: <200807200434.m6K4YT0m004106@smtp14.singnet.com.sg>
I have been informed that advice to increase the db_cache_size makes sense for an OLTP system but not a DSS system. That for a DSS system, the db_cache_size should not be large but the pga_aggregate_target should be large.
Are there any "best practices" , "test cases", "white papers", "benchmarks" which indicate such ?
Hemant K Chitale
http://hemantoracledba.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jul 19 2008 - 23:34:19 CDT