Re: buffer advisor

From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 6 Sep 2014 07:13:17 -0700
Message-ID: <1410012797.67366.YahooMailNeo_at_web184802.mail.gq1.yahoo.com>



I personally never look at the advisor. Neither do my coworkers. So I always set db_cache_advice to off.

If other advisory related parameters were not underscored, such as _library_cache_advice, _db_mttr_advice, _smm_advice_enabled, I would disable them too. (They can be disabled by statistics_level=basic but you lose too much good stuff with it.) I think they're related to various simulator activities and SGA memory chunks. The less the better.

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Sep 06 2014 - 16:13:17 CEST

Original text of this message