Database Administration (MOSC)

MOSC Banner

Oracle 11g

edited Aug 31, 2011 8:51AM in Database Administration (MOSC) 1 commentAnswered
I'm new to 11g.  I can not see last_analyzed column and statistics in dba_tables in my database. Does this mean the statis collection is not working?

select CLIENT_NAME from DBA_AUTOTASK_CLIENT returns

auto optimizer stats collection

auto space advisor

sql tuning advisor

select * from DBA_AUTOTASK_CLIENT_JOB returns

sql tuning advisor ORA$AT_SQ_SQL_SW_2174 RUNNING AUTO_SQL_TUNING_PROG SQL Workload automatic sql workload HIGH automatic sql tuning task
auto space advisor ORA$AT_SA_SPC_SY_2173 RUNNING auto_space_advisor_prog System system HIGH auto space advisor job
auto optimizer stats collection ORA$AT_OS_OPT_SY_2172 RUNNING gather_stats_prog System system HIGH auto optimizer stats job

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