autotask question
HI all
I have strange behavior on my 12g db 12.1.0.2 on AIX
Perhaps it's no strange behavior but
a have tried to find out if our statistics job work , but :
SELECT CLIENT_NAME ,
STATUS ,
MEAN_INCOMING_TASKS_7_DAYS,
MEAN_INCOMING_TASKS_30_DAYS
FROM DBA_AUTOTASK_CLIENT
WHERE CLIENT_NAME = 'auto optimizer stats collection'
/
and result is
CLIENT_NAME STATUS MEAN_INCOMING_TASKS_7_DAYS MEAN_INCOMING_TASKS_30_DAYS
---------------------------------------------------------------- -------- --------------------------------------- ---------------------------------------
auto optimizer stats collection ENABLED
attribute MEAN_INCOMING_TASKS_7_DAYS /MEAN_INCOMING_TASKS_30_DAYS are null , it means (I suppose that automaitic job doesn't work)
can You explain me why , it is any parameter how to stop it from init parameter ?