Re: Resource Manager

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-l