EXECUTE THIS PROCEDURE CALL TO CREATE A WINDOW NAMED DAYTIME THAT WILL ACTIVATE THE DAYTIME PLAN

6. Execute this procedure call to create a window named DAYTIME that will

activate the DAYTIME plan:

exec dbms_scheduler.create_window(-window_name=>'daytime',resource_plan=>'daytime',-start_date=>trunc(systimestamp) + 6/24,repeat_interval=>'freq=daily',-duration=>'0 12:00:00',comments=>'daily at 6AM');

This will open the window from now onward every morning at 6 o’clock, for

12 hours.