Re: ASMM - resizing triggers/thresholds
From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Mon, 4 Feb 2019 17:19:18 -0500
Message-ID: <CAMHX9JJNR-qnotSXs_aCF2+T1p3pixLaw4YQatH9dOQPOsnAKg_at_mail.gmail.com>
Date: Mon, 4 Feb 2019 17:19:18 -0500
Message-ID: <CAMHX9JJNR-qnotSXs_aCF2+T1p3pixLaw4YQatH9dOQPOsnAKg_at_mail.gmail.com>
Hi,
In addition to what Jonathan said, here are my ramblings about what the KGL simulator is (and the buffer cache simulator uses similar logic) that is used for modeling "time saved reloading objects/blocks into cache if we hadn't kicked them out previously":
-- Tanel Poder https://blog.tanelpoder.com/seminar/ On Sat, Feb 2, 2019 at 9:05 AM Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:Received on Mon Feb 04 2019 - 23:19:18 CET
>
> Martin,
>
> If you look for the hidden parameters like "%memory_broker%" that gives
> you some clues.
> 12.2.0.1
>
> NAME SES_VAL
> ---------------------------------------------
> ------------------------------
> _automemory_broker_interval 3
> _memory_broker_log_stat_entries 5
> _memory_broker_marginal_utility_bc 12
>
>
-- http://www.freelists.org/webpage/oracle-l