Print Friendly, PDF & Email
The post provides a number of steps to follow to run the Automatic Optimizer Statistics Collection Job with another time schedule.

REQUEST
I want the Automatic Optimizer Statistics Collection Job executes with another time schedule.

RELATED
ENSURING THAT MY DATABASE GATHERS STATISTICS ON A DAILY BASIS

SOLUTION
Ensure that the Automatic Optimizer Statistics Collection Job is ENABLED.

SET LINES 300 
SET PAGES 999
COL CLIENT_NAME FOR A35
COL CONSUMER_GROUP FOR A30 
COL WINDOW_GROUP FOR A20 
COL STATUS FOR A10 

SELECT CLIENT_NAME,
       STATUS,
       CONSUMER_GROUP,
       CLIENT_TAG,
       WINDOW_GROUP 
FROM 
       DBA_AUTOTASK_CLIENT;
CLIENT_NAME                         STATUS     CONSUMER_GROUP                 CLIENT WINDOW_GROUP
----------------------------------- ---------- ------------------------------ ------ --------------------
auto optimizer stats collection     ENABLED    ORA$AUTOTASK_STATS_GROUP       OS     ORA$AT_WGRP_OS
auto space advisor                  ENABLED    ORA$AUTOTASK_SPACE_GROUP       SA     ORA$AT_WGRP_SA
sql tuning advisor                  DISABLED   ORA$AUTOTASK_SQL_GROUP         SQ     ORA$AT_WGRP_SQ

Here is the Automatic Optimizer Statistics Collection Job is ENABLED and assigned to the ORA$AT_WGRP_OS window group.

Logically a window group is like a container with different schedules for the same job. By default the ORA$AT_WGRP_OS group has 7 schedules which called as the WINDOW NAME.

COL WINDOW_GROUP_NAME FOR A20
COL WINDOW_NAME FOR A20

SELECT * FROM DBA_SCHEDULER_WINGROUP_MEMBERS
WHERE WINDOW_GROUP_NAME='ORA$AT_WGRP_OS';
WINDOW_GROUP_NAME    WINDOW_NAME
-------------------- --------------------
ORA$AT_WGRP_OS       MONDAY_WINDOW
ORA$AT_WGRP_OS       TUESDAY_WINDOW
ORA$AT_WGRP_OS       WEDNESDAY_WINDOW
ORA$AT_WGRP_OS       THURSDAY_WINDOW
ORA$AT_WGRP_OS       FRIDAY_WINDOW
ORA$AT_WGRP_OS       SATURDAY_WINDOW
ORA$AT_WGRP_OS       SUNDAY_WINDOW

Every WINDOW NAME is linked to a specific day of the week and starts at a specific period of time. The DBA_SCHEDULER_WINDOWS view contains schedule details about every WINDOW NAME

SET LINES 300 
SET PAGES 999
COL WINDOW_NAME FOR A18
COL REPEAT_INTERVAL FOR A70 
COL DURATION FOR A15
COL SCHEDULE_NAME FOR A30

SELECT WINDOW_NAME,
       REPEAT_INTERVAL,
       DURATION,
       ENABLED 
FROM 
       DBA_SCHEDULER_WINDOWS;
WINDOW_NAME        REPEAT_INTERVAL                                                        DURATION        ENABLED
------------------ ---------------------------------------------------------------------- --------------- -------
WEEKNIGHT_WINDOW   freq=daily;byday=MON,TUE,WED,THU,FRI;byhour=22;byminute=0; bysecond=0  +000 08:00:00   FALSE
WEEKEND_WINDOW     freq=daily;byday=SAT;byhour=0;byminute=0;bysecond=0                    +002 00:00:00   FALSE
MONDAY_WINDOW      freq=daily;byday=MON;byhour=22;byminute=0; bysecond=0                  +000 04:00:00   TRUE
TUESDAY_WINDOW     freq=daily;byday=TUE;byhour=22;byminute=0; bysecond=0                  +000 04:00:00   TRUE
WEDNESDAY_WINDOW   freq=daily;byday=WED;byhour=22;byminute=0; bysecond=0                  +000 04:00:00   TRUE
THURSDAY_WINDOW    freq=daily;byday=THU;byhour=22;byminute=0; bysecond=0                  +000 04:00:00   TRUE
FRIDAY_WINDOW      freq=daily;byday=FRI;byhour=22;byminute=0; bysecond=0                  +000 04:00:00   TRUE
SATURDAY_WINDOW    freq=daily;byday=SAT;byhour=6;byminute=0; bysecond=0                   +000 20:00:00   TRUE
SUNDAY_WINDOW      freq=daily;byday=SUN;byhour=6;byminute=0; bysecond=0                   +000 20:00:00   TRUE

As can be seen from the above output the Monday-To-Friday WINDOW NAME start on Weekdays at 10PM and last for 4 hours, and the Saturday-To-Sunday WINDOW NAME start on Weekends at 6AM and last for 20 hours (almost for the whole day).

 
There are 2 options to schedule the Automatic Optimizer Statistics Collection Job at another time. Both options create a new WINDOW NAME.
Here I modify the schedule without touching an original WINDOW NAME. It might be useful if you want to have the ability to reset all changes fast.

 

Option 1 : Creates a WINDOW NAME using a Named Schedule Object

           a. Disable the Automatic Optimizer Statistics Collection Job [optional]
           b. Create a new Named Schedule Object 
           c. Create a new Window Name and assign a created Named Scheduled Object (b) to it
           d. Assign a created Windows Name (c) to the default Maintenance Group
           e. Enable the Automatic Optimizer Statistics Collection Job with a newly created Windows Name 
           f. Disable default Window Names

Option 2 : Creates a WINDOW NAME using an Inlined Schedule

           A. Disable the Automatic Optimizer Statistics Collection Job [optional]
           B. Create a new Windows Name with required repeat interval 
           C. Assign a created Windows Name (B) to the default Maintenance group 
           D. Enable the Automatic Optimizer Statistics Collection Job with a newly created Windows Name 
           E. Disable default Window Names

Both options are almost the same. The difference between them how they are scheduled – Named Schedule Object versus Inlined Schedule

 
Option 1 : Creates a Window Name using a Named Schedule Object

a. Disable the Automatic Optimizer Statistics Collection Job [optional]

-- Disable the job

BEGIN
   DBMS_AUTO_TASK_ADMIN.DISABLE(
   CLIENT_NAME => 'auto optimizer stats collection', 
   OPERATION   => NULL, 
   WINDOW_NAME => NULL);
END;
/

-- Confirm that it is disabled

SET LINES 300 
SET PAGES 999
COL CLIENT_NAME FOR A35
COL CONSUMER_GROUP FOR A30 
COL WINDOW_GROUP FOR A20 
COL STATUS FOR A10 

SELECT CLIENT_NAME, STATUS, CONSUMER_GROUP,
       CLIENT_TAG, WINDOW_GROUP 
FROM   DBA_AUTOTASK_CLIENT 
WHERE  CLIENT_NAME='auto optimizer stats collection';
CLIENT_NAME                         STATUS     CONSUMER_GROUP                 CLIENT WINDOW_GROUP
----------------------------------- ---------- ------------------------------ ------ --------------------
auto optimizer stats collection     DISABLED   ORA$AUTOTASK_STATS_GROUP       OS     ORA$AT_WGRP_OS

b. Create a new Named Schedule Object. In this example, the schedule will start at 10AM from Monday to Friday only. A name of a new Named Schedule Object (see SCHEDULE_NAME parameter) can be anything you want.

-- Define any name for a new Named Schedule Object

DEFINE SCHEDULE_NAME = 'GATHER_STATS_SCHEDULE'


-- Create a new Named Schedule Object

BEGIN 
   DBMS_SCHEDULER.CREATE_SCHEDULE(
   SCHEDULE_NAME   => '&SCHEDULE_NAME',
   START_DATE      => SYSTIMESTAMP,
   REPEAT_INTERVAL => 'freq=daily;byday=MON,TUE,WED,THU,FRI;byhour=10;byminute=0; bysecond=0',
   END_DATE        => NULL, 
   COMMENTS        => 'REPEATS DAILY (MON-FRI) AT 10AM FOREVER.');
END;
/

-- To remove the created Named Scheduled Object

-- BEGIN 
-- DBMS_SCHEDULER.DROP_SCHEDULE(SCHEDULE_NAME => 'GATHER_STATS_SCHEDULE');
-- END;
-- /

-- Query repeat interval for the created Named Scheduled Object 

SET LINES 300
SET PAGES 999
COL OWNER FOR A5 
COL SCHEDULE_NAME FOR A23
col START_DATE for a40 
col REPEAT_INTERVAL for a70 
col END_DATE for a10 
col COMMENTS for a40

SELECT OWNER, SCHEDULE_NAME, REPEAT_INTERVAL 
FROM   DBA_SCHEDULER_SCHEDULES 
WHERE  SCHEDULE_NAME='&SCHEDULE_NAME';

OWNER SCHEDULE_NAME           REPEAT_INTERVAL
----- ----------------------- ----------------------------------------------------------------------
SYS   GATHER_STATS_SCHEDULE   freq=daily;byday=MON,TUE,WED,THU,FRI;byhour=10;byminute=0; bysecond=0

-- Query when the created Named Schedule Object will be started

SELECT START_DATE, END_DATE, COMMENTS 
FROM  DBA_SCHEDULER_SCHEDULES 
WHERE SCHEDULE_NAME='&SCHEDULE_NAME';

START_DATE                               END_DATE   COMMENTS
---------------------------------------- ---------- ----------------------------------------
20-NOV-17 03.02.32.288838 PM +03:00                 REPEATS DAILY (MON-FRI) AT 10AM FOREVER.

c. Create a new Window Name and assign a created Named Scheduled Object (b) to it. A name of a new Window Name (see WINDOW_NAME parameter) can be anything you want. In this example, the duration of a new Window Name is 4 hours.

-- Define any name for a new Window Name

DEFINE WINDOW_NAME = 'GATHERSTATISTICS_MON_FRI'

-- Create a new Window Name with the GATHER_STATS_SCHEDULE assigned to it

BEGIN   
	DBMS_SCHEDULER.CREATE_WINDOW ( 
	WINDOW_NAME     => '&WINDOW_NAME',
	RESOURCE_PLAN   => 'DEFAULT_MAINTENANCE_PLAN',
	SCHEDULE_NAME   => 'GATHER_STATS_SCHEDULE',
	DURATION        => interval '4' hour, 
	WINDOW_PRIORITY => 'LOW',
	COMMENTS        => 'Weekdays Gather Statistic Job. Used instead of default window names.');
END;
/

-- To remove the created Window Name

-- BEGIN   
-- DBMS_SCHEDULER.DROP_WINDOW (window_name => 'GATHERSTATISTICS_MON_FRI');
-- END;
-- /


-- Confirm that the Windows Name is created

SET LINES 300 
SET PAGES 999
COL WINDOW_NAME for a25
COL REPEAT_INTERVAL FOR A15
COL DURATION FOR A15
COL SCHEDULE_NAME FOR A21
COL ENABLED FOR A7

SELECT WINDOW_NAME,REPEAT_INTERVAL,DURATION,SCHEDULE_NAME,ENABLED 
FROM   DBA_SCHEDULER_WINDOWS 
WHERE  WINDOW_NAME=UPPER('&WINDOW_NAME');
old   3: WHERE  WINDOW_NAME=UPPER('&WINDOW_NAME')
new   3: WHERE  WINDOW_NAME=UPPER('GATHERSTATISTICS_MON_FRI')

WINDOW_NAME               REPEAT_INTERVAL DURATION        SCHEDULE_NAME         ENABLED
------------------------- --------------- --------------- --------------------- -------
GATHERSTATISTICS_MON_FRI                  +000 04:00:00   GATHER_STATS_SCHEDULE TRUE

d. Assign a created Windows Name (c) to the default Maintenance Group. The default Maintenance Group is used for automated tasks

-- Add the created Window Name to the Window Group
-- DEFINE WINDOW_NAME = 'GATHERSTATISTICS_MON_FRI'

BEGIN   
   DBMS_SCHEDULER.ADD_GROUP_MEMBER(
   GROUP_NAME => 'MAINTENANCE_WINDOW_GROUP',
   MEMBER     => '&WINDOW_NAME');
END;
/


-- To exclude the created Window Name from the Window Group

-- BEGIN   
--   DBMS_SCHEDULER.REMOVE_GROUP_MEMBER(
--   GROUP_NAME => 'MAINTENANCE_WINDOW_GROUP',
--   MEMBER     => 'GATHERSTATISTICS_MON_FRI');
-- END;
-- /

e. Enable the Automatic Optimizer Statistics Collection Job with a newly created Windows Name

-- Enable the job
-- DEFINE WINDOW_NAME = 'GATHERSTATISTICS_MON_FRI'

BEGIN
   DBMS_AUTO_TASK_ADMIN.ENABLE(
   CLIENT_NAME => 'auto optimizer stats collection', 
   OPERATION   => NULL, 
   WINDOW_NAME => '&WINDOW_NAME');
END;
/

-- Confirm that it is enabled

SET LINES 300 
SET PAGES 999
COL CLIENT_NAME FOR A31
COL CONSUMER_GROUP FOR A25
COL WINDOW_GROUP FOR A15 
COL STATUS FOR A7 

SELECT CLIENT_NAME,STATUS,CONSUMER_GROUP,CLIENT_TAG,WINDOW_GROUP 
FROM   DBA_AUTOTASK_CLIENT 
WHERE  CLIENT_NAME='auto optimizer stats collection';

CLIENT_NAME                     STATUS  CONSUMER_GROUP            CLIENT WINDOW_GROUP
------------------------------- ------- ------------------------- ------ ---------------
auto optimizer stats collection ENABLED ORA$AUTOTASK_STATS_GROUP  OS     ORA$AT_WGRP_OS

-- Verify that created Window Name are in the list of the Window Group

COL WINDOW_GROUP_NAME for a20 
SELECT * from DBA_SCHEDULER_WINGROUP_MEMBERS 
WHERE WINDOW_GROUP_NAME='ORA$AT_WGRP_OS';

WINDOW_GROUP_NAME    WINDOW_NAME
-------------------- ------------------------------
ORA$AT_WGRP_OS       MONDAY_WINDOW
ORA$AT_WGRP_OS       TUESDAY_WINDOW
ORA$AT_WGRP_OS       WEDNESDAY_WINDOW
ORA$AT_WGRP_OS       THURSDAY_WINDOW
ORA$AT_WGRP_OS       FRIDAY_WINDOW
ORA$AT_WGRP_OS       SATURDAY_WINDOW
ORA$AT_WGRP_OS       SUNDAY_WINDOW
ORA$AT_WGRP_OS       GATHERSTATISTICS_MON_FRI

-- Statuses of all available Window Names in the Window Group

COL WINDOW_NAME FOR A25
COL WINDOW_NEXT_TIME for a35
COL STATUS FOR A15
COL OPTIMIZER_STATS FOR A15 

SELECT WINDOW_NAME,WINDOW_NEXT_TIME,AUTOTASK_STATUS STATUS,OPTIMIZER_STATS 
FROM DBA_AUTOTASK_WINDOW_CLIENTS;

WINDOW_NAME               WINDOW_NEXT_TIME                    STATUS          OPTIMIZER_STATS
------------------------- ----------------------------------- --------------- ---------------
MONDAY_WINDOW             22-JAN-18 10.00.00.000000 PM +03:00 ENABLED         ENABLED
TUESDAY_WINDOW            16-JAN-18 10.00.00.000000 PM +03:00 ENABLED         ENABLED
WEDNESDAY_WINDOW          17-JAN-18 10.00.00.000000 PM +03:00 ENABLED         ENABLED
THURSDAY_WINDOW           18-JAN-18 10.00.00.000000 PM +03:00 ENABLED         ENABLED
FRIDAY_WINDOW             19-JAN-18 10.00.00.000000 PM +03:00 ENABLED         ENABLED
SATURDAY_WINDOW           20-JAN-18 06.00.00.000000 AM +03:00 ENABLED         ENABLED
SUNDAY_WINDOW             21-JAN-18 06.00.00.000000 AM +03:00 ENABLED         ENABLED
GATHERSTATISTICS_MON_FRI  16-JAN-18 10.00.00.000000 AM +03:00 ENABLED         ENABLED

f. Disable default Window Names

-- Disable defaults through the LOOP 
-- DEFINE WINDOW_NAME = 'GATHERSTATISTICS_MON_FRI'

BEGIN 
FOR W IN (SELECT WINDOW_NAME FROM DBA_AUTOTASK_WINDOW_CLIENTS 
          WHERE WINDOW_NAME!='&WINDOW_NAME')
LOOP
    BEGIN
       dbms_auto_task_admin.disable(
       client_name => 'auto optimizer stats collection', 
       operation   => NULL, 
       window_name => W.WINDOW_NAME);
    END;
END LOOP;
END;
/

-- Confirm that all default Window Names are disabled

COL WINDOW_NAME FOR A25
COL WINDOW_NEXT_TIME for a35
COL STATUS FOR A15
COL OPTIMIZER_STATS FOR A15 

SELECT WINDOW_NAME,WINDOW_NEXT_TIME,AUTOTASK_STATUS STATUS,OPTIMIZER_STATS 
FROM DBA_AUTOTASK_WINDOW_CLIENTS;

WINDOW_NAME               WINDOW_NEXT_TIME                    STATUS          OPTIMIZER_STATS
------------------------- ----------------------------------- --------------- ---------------
MONDAY_WINDOW             22-JAN-18 10.00.00.000000 PM +03:00 ENABLED         DISABLED
TUESDAY_WINDOW            16-JAN-18 10.00.00.000000 PM +03:00 ENABLED         DISABLED
WEDNESDAY_WINDOW          17-JAN-18 10.00.00.000000 PM +03:00 ENABLED         DISABLED
THURSDAY_WINDOW           18-JAN-18 10.00.00.000000 PM +03:00 ENABLED         DISABLED
FRIDAY_WINDOW             19-JAN-18 10.00.00.000000 PM +03:00 ENABLED         DISABLED
SATURDAY_WINDOW           20-JAN-18 06.00.00.000000 AM +03:00 ENABLED         DISABLED
SUNDAY_WINDOW             21-JAN-18 06.00.00.000000 AM +03:00 ENABLED         DISABLED
GATHERSTATISTICS_MON_FRI  16-JAN-18 10.00.00.000000 AM +03:00 ENABLED         ENABLED

To reset all changes made in the Option 1

-- Names for the Named Schedule Object and Window Name

DEFINE SCHEDULE_NAME = 'GATHER_STATS_SCHEDULE'
DEFINE WINDOW_NAME = 'GATHERSTATISTICS_MON_FRI'

-- Drop the Named Schedule Object and Window Name

EXEC DBMS_SCHEDULER.DROP_WINDOW(WINDOW_NAME => '&WINDOW_NAME');
EXEC DBMS_SCHEDULER.DROP_SCHEDULE(SCHEDULE_NAME => '&SCHEDULE_NAME');


-- Enable default Window Names 

BEGIN 
FOR W IN (SELECT WINDOW_NAME FROM DBA_AUTOTASK_WINDOW_CLIENTS)
LOOP
    BEGIN
       DBMS_AUTO_TASK_ADMIN.ENABLE(
       CLIENT_NAME => 'auto optimizer stats collection', 
       OPERATION   => NULL, 
       WINDOW_NAME => W.WINDOW_NAME);
    END;
END LOOP;
END;
/

-- Confirm that all default Window Names are enabled

COL WINDOW_NAME FOR A25
COL WINDOW_NEXT_TIME for a35
COL STATUS FOR A15
COL OPTIMIZER_STATS FOR A15 

SELECT WINDOW_NAME,WINDOW_NEXT_TIME,AUTOTASK_STATUS STATUS,OPTIMIZER_STATS 
FROM DBA_AUTOTASK_WINDOW_CLIENTS;

 
Option 2 : Creates a Window Name using an Inlined Schedule

A. Disable the Automatic Optimizer Statistics Collection Job [optional] by the same way as described in the Option 1 step a

B. Create a new Windows Name with required REPEAT_INTERVAL. In this example a new Windows Name will start at 4AM and last for 5 hours

-- Define any name for a new Window Name

DEFINE WINDOW_NAME = 'GATHERSTATISTICS_MON_FRI_OP2'

BEGIN   
   DBMS_SCHEDULER.CREATE_WINDOW ( 
   WINDOW_NAME     => '&WINDOW_NAME',
   RESOURCE_PLAN   => 'DEFAULT_MAINTENANCE_PLAN',
   START_DATE      => SYSTIMESTAMP,
   REPEAT_INTERVAL => 'freq=daily;byday=MON,TUE,WED,THU,FRI;byhour=4;byminute=0; bysecond=0',
   END_DATE        => NULL,
   DURATION        => interval '5' hour, 
   WINDOW_PRIORITY => 'LOW',
   COMMENTS        => 'Custom Window Name for the Gather Statistics Job. Starts at 4am and last for 5 hours.');
END;
/

-- To remove the created Window Name

-- BEGIN   
-- DBMS_SCHEDULER.DROP_WINDOW (window_name => 'GATHERSTATISTICS_MON_FRI_OP2');
-- END;
-- /

-- Confirm that the Windows Name is created

SET LINES 300 
SET PAGES 999
COL WINDOW_NAME FOR A28
COL REPEAT_INTERVAL FOR A70 
COL DURATION FOR A15
COL SCHEDULE_NAME FOR A30

SELECT WINDOW_NAME,REPEAT_INTERVAL,DURATION,ENABLED 
FROM   DBA_SCHEDULER_WINDOWS
WHERE  WINDOW_NAME=UPPER('&WINDOW_NAME');
old   3: WHERE  WINDOW_NAME=UPPER('&WINDOW_NAME')
new   3: WHERE  WINDOW_NAME=UPPER('GATHERSTATISTICS_MON_FRI_OP2')

WINDOW_NAME                  REPEAT_INTERVAL                                                      DURATION      ENABLED 
---------------------------- -------------------------------------------------------------------- ------------- -------
GATHERSTATISTICS_MON_FRI_OP2 freq=daily;byday=MON,TUE,WED,THU,FRI;byhour=4;byminute=0; bysecond=0 +000 05:00:00 TRUE

C. Assign a created Windows Name (B) to the default Maintenance group (same as the Option 1 steps d).
D. Enable the Automatic Optimizer Statistics Collection Job with a newly created Windows Name (same as the Option 1 steps e).
E. Disable default Window Names (same as the Option 1 steps f).

To reset all changes made in the Option 2

-- Names for the Named Schedule Object and Window Name

DEFINE WINDOW_NAME = 'GATHERSTATISTICS_MON_FRI_OP2'

-- Drop the Window Name

EXEC DBMS_SCHEDULER.DROP_WINDOW(WINDOW_NAME => '&WINDOW_NAME');


-- Enable default Window Names 

BEGIN 
FOR W IN (SELECT WINDOW_NAME FROM DBA_AUTOTASK_WINDOW_CLIENTS)
LOOP
    BEGIN
       DBMS_AUTO_TASK_ADMIN.ENABLE(
       CLIENT_NAME => 'auto optimizer stats collection', 
       OPERATION   => NULL, 
       WINDOW_NAME => W.WINDOW_NAME);
    END;
END LOOP;
END;
/

-- Confirm that all default Window Names are enabled

COL WINDOW_NAME FOR A25
COL WINDOW_NEXT_TIME for a35
COL STATUS FOR A15
COL OPTIMIZER_STATS FOR A15 

SELECT WINDOW_NAME,WINDOW_NEXT_TIME,AUTOTASK_STATUS STATUS,OPTIMIZER_STATS 
FROM DBA_AUTOTASK_WINDOW_CLIENTS;

 
To get historic details about all the Automatic Optimizer Statistics Collection Job executions

-- Specify how many rows you want the query to returns

DEFINE ROWNUM = 5

SET LINES 300
SET PAGES 999
COL WINDOW_NAME FOR A25
COL WINDOW_START_TIME FOR A20 
COL JOB_NAME FOR A22 
COL JOB_START_TIME_MAN FOR A20 
COL JOB_DURATION FOR A15 
COL JOB_INFO FOR A2 
COL JOB_STATUS FOR A10 
COL WINDOW_DURATION FOR A26 

SELECT * FROM (
       SELECT WINDOW_NAME,
              TO_CHAR(WINDOW_START_TIME,'DD-MM-YYYY HH24:MI:SS') WINDOW_START_TIME,
              WINDOW_DURATION,
              JOB_NAME,
              JOB_STATUS,
              TO_CHAR(JOB_START_TIME,'DD-MM-YYYY HH24:MI:SS') JOB_START_TIME_MAN,
              JOB_DURATION,
              JOB_ERROR 
       FROM DBA_AUTOTASK_JOB_HISTORY 
       WHERE CLIENT_NAME='auto optimizer stats collection' 
      ORDER BY JOB_START_TIME DESC
) WHERE ROWNUM < '&ROWNUM';
WINDOW_NAME               WINDOW_START_TIME    WINDOW_DURATION            JOB_NAME               JOB_STATUS JOB_START_TIME_MAN   JOB_DURATION     JOB_ERROR
------------------------- -------------------- -------------------------- ---------------------- ---------- -------------------- --------------- ----------
GATHERSTATISTICS_MON_FRI  16-01-2018 10:00:00  +000000000 03:59:59.991223 ORA$AT_OS_OPT_SY_10742 SUCCEEDED  16-01-2018 10:00:01  +000 00:01:06            0
GATHERSTATISTICS_MON_FRI  15-01-2018 10:00:00  +000000000 03:59:59.923946 ORA$AT_OS_OPT_SY_10722 SUCCEEDED  15-01-2018 10:00:02  +000 00:03:22            0
GATHERSTATISTICS_MON_FRI  12-01-2018 10:00:01  +000000000 03:59:59.030701 ORA$AT_OS_OPT_SY_10664 SUCCEEDED  12-01-2018 10:00:02  +000 00:01:18            0
GATHERSTATISTICS_MON_FRI  11-01-2018 10:00:00  +000000000 04:00:00.153721 ORA$AT_OS_OPT_SY_10662 SUCCEEDED  11-01-2018 10:00:01  +000 00:04:08            0

 
 

Version  : 14:26 16.01.2018
Platform : Oracle Linux Server 7.3
Database : Oracle database 11.2.0.4