Re: Resource Manager

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_at_bluewin.ch
> <mailto:l.flatz_at_bluewin.ch>> 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
>
>
>
> --
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

-- 





--
http://www.freelists.org/webpage/oracle-l