Database Tuning (MOSC)

MOSC Banner

auto optimizer stats collection Job not running

edited Jan 18, 2018 4:00AM in Database Tuning (MOSC) 12 commentsAnswered

Even though the auto task jobs are enabled we have observed that they are not running.

1* select CLIENT_NAME,STATUS,CONSUMER_GROUP,WINDOW_GROUP from dba_autotask_client

SQL> /

CLIENT_NAME STATUS CONSUMER_GROUP WINDOW_GROUP

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

auto optimizer stats collection ENABLED ORA$AUTOTASK ORA$AT_WGRP_OS

auto space advisor ENABLED ORA$AUTOTASK ORA$AT_WGRP_SA

sql tuning advisor ENABLED ORA$AUTOTASK ORA$AT_WGRP_SQ

Last week we had an issue in prod when the cpu utilization was almost 100% when the gather stats were runningand awr report shows Resmgr:Cpu Quantum wait event. So as per the

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