Re: Resource Manager

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