Database Administration (MOSC)

MOSC Banner

Dictionary and Fixed object stats - 19c

Hello All

We have a couple of questions on the FIXED and DICTIONARY STATS 

Ours is 19.13.0.0.0 database ; 2 node RAC

Here is some relevant info

DBA_AUTOTASK_CLIENT shows the following

CLIENT_NAME           STATUS  CONSUMER_GROUP CLIENT_TAG ATTRIBUTES                      WINDOW_GROUP  

auto space advisor ENABLED ORA$AUTOTASK  SA     ON BY DEFAULT,VOLATILE, SAFE TO KILL         ORA$AT_WGRP_SA

auto optimizer stats collection ENABLED ORA$AUTOTASK  OS     ON BY DEFAULT,VOLATILE, SAFE TO KILL         ORA$AT_WGRP_OS

sql tuning advisor ENABLED ORA$AUTOTASK  SQ     ONCE PER WINDOW,ON BY DEFAULT, VOLATILE, SAFE TO KILL ORA$AT_WGRP_SQ

SELECT * FROM DBA_AUTOTASK_CLIENT_JOB show NO RECORDS though

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