Re: Question on db_cache_size

From: Jay Weinshenker <jweinshe_at_concentric.net>
Date: Mon, 18 Jul 2011 09:24:53 -0400
Message-Id: <1310995493.14942.2153018593_at_webmail.messagingengine.com>

Kumar,

On my 11.2.0.1 11.5.10.2 ATG RUP 7 DB, I don't explicitly set db_cache_size but instead it's set by sga_target and sga_max_size components of ASMM (automatic shared memory management) - I'd highly recommend you use ASMM (and not AMM) and let the database do what it things it's best. Having said that, I do also specify a minimum java_pool_size.

Hope that helps.

J
--

Jay Weinshenker
jweinshe_at_concentric.net

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jul 18 2011 - 08:24:53 CDT

This message: [ Message body ]
Next message: Jorgensen, Finn: "RE: stats in 11g"
Previous message: Laimutis.Nedzinskas_at_seb.lt: "Re: Is a RDBMS needed?"
Maybe in reply to: Kumar Madduri: "Question on db_cache_size"
Next in thread: Riyaj Shamsudeen: "Re: Question on db_cache_size"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message