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>

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-l
Received on Sat Jul 19 2008 - 23:34:19 CDT

Original text of this message