Hi Lothar,
Can you get us the output for the below?
Select name,value from v$parameter where name='resource_manager_plan';
I had observed that even though "sho parameter resource" was not showing
any plan, the above query was listing the default maintenance plan. For me
this happened on 11204 version database..
BR,
Rakesh RA
On Tue, Apr 14, 2020, 19:53 Lothar Flatz <l.flatz@xxxxxxxxxx> wrote:
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
--
--
//www.freelists.org/webpage/oracle-l
