Database Administration (MOSC)

MOSC Banner

question regarding gather schema statistics

edited Aug 22, 2013 7:45AM in Database Administration (MOSC) 5 commentsAnswered
I have setup the cron job to run gather schema statistics once a month.

exec dbms_stats.gather_schema_stats(ownname =>'QC_SYS',cascade => TRUE, method_opt => 'FOR ALL COLUMNS SIZE AUTO', estimate_percent => dbms_stats.auto_sample
_size, options => 'GATHER AUTO');

However, when I checked select table_name, last_analyzed from dba_tables where owner='QC_SYS';

Some of the table showed last analyzed as this month, some showed last month. some showed as April of last year. My question is how does the gather schema stats pick which table to analyze? I thought it would analyze all the tables under the schema. Gurus, could you please explain? Thanks.

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