Re: Resource Manager
Date: Tue, 14 Apr 2020 18:31:39 +0200 (CEST)
Message-ID: <1643780300.916212.1586881900055_at_ox.hosteurope.de>
Hello Lothar,
at first please let me point to the corresponding official Oracle white paper: https://www.oracle.com/technetwork/database/performance/instance-caging-wp-166854.pdf
> Would explicit setting CPU_COUNT activate Resource Manager outside of maintenance windows?
I guess you are referring more to instance caging - so the interaction between cpu_count and resource manager. CPU is only limited (aka. caged) if you have an enabled resource plan with "cpu_managed = ON". The DEFAULT_MAINTENANCE_PLAN is "cpu_managed = ON" and so you got this CPU limit of cpu_count in this time window. In consequence CPU caging is not active outside this time window by default :-)
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: _at_OracleSK
> Lothar Flatz <l.flatz_at_bluewin.ch> hat am 14. April 2020 um 16:22 geschrieben:
>
> Hi,
>
> Resource Manager Plan is not Set. AWR reports
> "SCHEDULER[0x32D9]:DEFAULT_MAINTENANCE_PLAN".
> Parameter CPU_COUNT is not set.
> My understanding is : Resource Manager is active during maintenance
> windows only.
> CPU_COUNT will be derived. It does not matter if it is set or not.
> Would explicit setting CPU_COUNT activate Resource Manager outside of
> maintenance windows?
> Would setting CPU_COUNT to the default value (os cores * 2) make a
> difference to not setting a value?
>
> Regards
> Lothar
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 14 2020 - 18:31:39 CEST