690 shaares
3 liens privés
3 liens privés
To follow Oracle statistics daily execution :
select * from DBA_AUTOTASK_CLIENT_HISTORY ;
select * from DBA_AUTOTASK_JOB_HISTORY;
select * from DBA_AUTOTASK_JOB_HISTORY where WINDOW_START_TIME > TO_DATE('27/02/19','DD-MM-YY') and client_name = 'auto optimizer stats collection';
ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'DEFAULT_MAINTENANCE_PLAN';
exec DBMS_AUTO_TASK_IMMEDIATE.GATHER_OPTIMIZER_STATS;
// see JOB_INFO column
Ex : ORA-29373: resource manager is not on