Hi,
the query results in NULL.
Even though I think the default maintenance plan is active as AWR suggests.
I think it is not configured via the parameter.
Regards
Lothar
Am 14.04.2020 um 16:44 schrieb Rakesh Ra:
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 <mailto: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