{16 追加}メンテナンス・ウィンドウの期間の変更

 

https://docs.oracle.com/cd/F19136_01/admin/managing-automated-database-maintenance-tasks.html#GUID-A4FA16ED-9575-4EBF-8EE1-904F58FD4D8E

sqlplus sys/oracle@pdb11 as sysdba

select * from DBA_AUTOTASK_WINDOW_CLIENTS;
select * from DBA_SCHEDULER_WINDOWS;

BEGIN
  dbms_scheduler.disable(
    name  => 'SATURDAY_WINDOW');
  dbms_scheduler.set_attribute(
    name      => 'SATURDAY_WINDOW',
    attribute => 'DURATION',
    value     => numtodsinterval(3, 'hour'));
  dbms_scheduler.enable(
    name => 'SATURDAY_WINDOW');
END;
/

 

select * from DBA_AUTOTASK_WINDOW_CLIENTS;
select * from DBA_SCHEDULER_WINDOWS;

 

BEGIN
  dbms_scheduler.disable(
    name  => 'SATURDAY_WINDOW');
  dbms_scheduler.set_attribute(
    name      => 'SATURDAY_WINDOW',
    attribute => 'repeat_interval',
    value     => 'freq=daily;byday=SAT;byhour=9;byminute=10; bysecond=20');
  dbms_scheduler.enable(
    name => 'SATURDAY_WINDOW');
END;
/

 

select * from DBA_AUTOTASK_WINDOW_CLIENTS;
select * from DBA_SCHEDULER_WINDOWS;