Resource Manager Plan Changes Settings Every Week

简介: Resource Manager Plan Changes Settings Every Week

ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'FORCE:' scope=both; --> For Null

Change the active windows to use the null resource manager plan (or other unrestrictive plan) using:

execute dbms_scheduler.set_attribute('WEEKNIGHT_WINDOW','RESOURCE_PLAN','');
--And
execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');

select from v$rsrc_plan;
select
from V$RSRC_PLAN_HISTORYorder by SEQUENCE#;

相关文章
|
8月前
Manage Audit File Directory Growth with cron (Doc ID 1298957.1)
Manage Audit File Directory Growth with cron (Doc ID 1298957.1)
43 3
This job is stuck, because the project doesn‘t have any runners online assigned to it. Go to Runners
This job is stuck, because the project doesn‘t have any runners online assigned to it. Go to Runners
This job is stuck, because the project doesn‘t have any runners online assigned to it. Go to Runners
|
索引
Resource temporarily unavailable, will not index. Try --rotate option.
Resource temporarily unavailable, will not index. Try --rotate option.
186 1
|
Oracle 关系型数据库
How to Recreate the Automatic Workload Repository (AWR)? (Doc ID 782974.1)
How to Recreate the Automatic Workload Repository (AWR)? (Doc ID 782974.1)
203 0
|
SQL Oracle 关系型数据库
Troubleshooting: Missing Automatic Workload Repository (AWR) Snapshots and Other Collection Issues (Doc ID 1301503.1)
Troubleshooting: Missing Automatic Workload Repository (AWR) Snapshots and Other Collection Issues (Doc ID 1301503.1)
776 0
|
安全 对象存储
set_time_limit() has been disabled for security reasons
set_time_limit() has been disabled for security reasons
177 0
set_time_limit() has been disabled for security reasons
MGA (Managed Global Area) Reference Note (Doc ID 2638904.1)
MGA (Managed Global Area) Reference Note (Doc ID 2638904.1)
344 0