Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Gather stats in oracle 11g

SGUJun 5 2019 — edited Jun 6 2019

Dear Experts,

Need your help

I have recently put to handle non erp databases.In erp,we will schedule gather schema stats program which will run daily at morning 4:00am and gather the stats.

In core databases,i would like to understand if stats was really running in this environment.can you please suggest with below data.

Version 11g

SQL> select client_name,status,attributes,resource_percentage,mean_job_duration from dba_autotask_client where client_name like '%STATS%';

no rows selected

SQL> select window_name, autotask_status, optimizer_stats from dba_autotask_window_clients;

WINDOW_NAME AUTOTASK OPTIMIZE

------------------------------ -------- --------

MONDAY_WINDOW ENABLED ENABLED

WEDNESDAY_WINDOW ENABLED ENABLED

FRIDAY_WINDOW ENABLED ENABLED

SATURDAY_WINDOW ENABLED ENABLED

THURSDAY_WINDOW ENABLED ENABLED

TUESDAY_WINDOW ENABLED ENABLED

SUNDAY_WINDOW ENABLED ENABLED

7 rows selected.

select * from DBA_AUTOTASK_SCHEDULE order by start_time;

TUESDAY_WINDOW 25-JUN-19 10.00.00.500000 PM + +000 04:00:00
05:30
WEDNESDAY_WINDOW 26-JUN-19 10.00.00.500000 PM + +000 04:00:00
05:30
THURSDAY_WINDOW 27-JUN-19 10.00.00.500000 PM + +000 04:00:00
05:30
FRIDAY_WINDOW 28-JUN-19 10.00.00.500000 PM + +000 04:00:00
05:30
SATURDAY_WINDOW 29-JUN-19 06.00.00.500000 AM + +000 20:00:00
05:30
SUNDAY_WINDOW 30-JUN-19 06.00.00.500000 AM + +000 20:00:00
05:30
MONDAY_WINDOW 01-JUL-19 10.00.00.500000 PM + +000 04:00:00
05:30
TUESDAY_WINDOW 02-JUL-19 10.00.00.500000 PM + +000 04:00:00
05:30

WEDNESDAY_WINDOW 03-JUL-19 10.00.00.500000 PM + +000 04:00:00