SQL Performance (MOSC)

MOSC Banner

Gathering Data Dictionary Statistics

edited Oct 8, 2014 4:36PM in SQL Performance (MOSC) 11 commentsAnswered ✓

Hello.  When gathering Data Dictionary Statistics do the following 2 dbms_stats commands do the same exact thing:

exec DBMS_STATS.GATHER_DATABASE_STATS (gather_sys=>TRUE);

EXEC DBMS_STATS.GATHER_DICTIONARY_STATS


My thought from past experience is that they do but wanted to confirm. 

And, after executing the above commands how can I prove that statistics were gathered for the Data Dictionary tables?  I've been reviewing some Metalink Notes and from them was selecting from dba_tables where owner='SYS' and looking at the last_analyzed column but I didn't all the last_analyzed column values to have the current date for which I ran the above commands?  There were records with the current date but not all of them?  Thanks for your help.

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