set long 400set pagesize 1000set linesize 120column log_date format a37column operation format a8column status format a6column additional_info format a400column systimestamp format a37column next_start_date format a40column start_date format a40column manual_open_time format a40column manual_duration format a40column duration format a40column end_date format a40column last_start_date format a40column window_name format a26column systimestamp format a35column ATTR_INTV format a37column ATTR_TSTAMP format a37column start_time format a35column obj_name format a20column name format a30column value format a30column job_queue_name format a18column job_type format 9999column flag format 9999column status format a6column "SEQUENCE#" format 9999column id format 99999spool wintestselect * from dba_scheduler_windows ;select log_date, window_name, operation,status, substr(additional_info,1,350) from dba_scheduler_window_log order by 1 ;select window_name, substr(additional_info,1,350) x from dba_scheduler_window_log where additional_info is not null;-- Report current time in scheduler formatselect dbms_scheduler.stime from dual;-- Report Internal Queues v10.2(before)select job_queue_name,   JOB_TYPE,    (select object_name from dba_objects where object_id = job_oid      ) OBJ_NAME,  FLAG, start_time from x$jskjobq;-- Report current open window attributes(before)SELECT o.name, o.namespace, a.*　FROM sys.obj$ o, sys.scheduler$_global_attribute a　　WHERE o.obj# = a.obj# AND BITAND(a.flags,1) != 1　　　AND o.name = 'CURRENT_OPEN_WINDOW' AND o.namespace = 51;-- To implement the solution, please execute the following steps::exec dbms_scheduler.disable('WEEKEND_WINDOW');exec dbms_scheduler.disable('WEEKNIGHT_WINDOW');exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED', 'TRUE');select value from v$parameter where name='job_queue_processes';alter system set job_queue_processes=0;exec dbms_ijob.set_enabled(FALSE);alter system flush shared_pool;alter system flush shared_pool;declarecwo number;beginselect o.obj# into cwo from sys.obj$ o  where o.name = 'CURRENT_OPEN_WINDOW' and o.namespace = 51;update sys.scheduler$_global_attribute set value = null, attr_tstamp = null,attr_intv = null, additional_info = null where obj# = cwo;end;/exec dbms_ijob.set_enabled(TRUE);exec dbms_scheduler.enable('WEEKEND_WINDOW');exec dbms_scheduler.enable('WEEKNIGHT_WINDOW');exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED', 'FALSE');exec dbms_ijob.set_enabled(TRUE);-- Report current time in scheduler formatselect dbms_scheduler.stime from dual;-- Report Internal Queues v10.2(after)select job_queue_name, JOB_TYPE, (select object_name from dba_objects where object_id = job_oid  ) OBJ_NAME, FLAG, start_time from x$jskjobq;-- Report current open window attributes(after)SELECT o.name, o.namespace, a.* FROM sys.obj$ o, sys.scheduler$_global_attribute a  WHERE o.obj# = a.obj# AND BITAND(a.flags,1) != 1   AND o.name = 'CURRENT_OPEN_WINDOW' AND o.namespace = 51;ACCEPT J_NUM NUMBER PROMPT "Enter job_queue_processes: "prompt Setting job_queue_processes=&&J_NUMalter system set job_queue_processes=&&J_NUM;select value from v$parameter where name='job_queue_processes';spool off