Database Administration (MOSC)

MOSC Banner

autotask question

edited Nov 6, 2018 10:49AM in Database Administration (MOSC) 3 commentsAnswered ✓

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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center