Database Tuning (MOSC)

MOSC Banner

How to find out how long does gatherstats run for each table

edited Dec 1, 2010 1:06AM in Database Tuning (MOSC) 2 commentsAnswered
 Hi,

I am using gather_schema_stats to gather statistics for a specific schema.  I am using parallel=5 and method is default (means = gather).  The database in question is of 10.2.0.3 version.

Question is how can I find out how long does the gather stats run for each table?  I have been comparing last_analyzed from dba_tables and order by table_name to get the gather stats duration as I know gather_schema_stats gathers the tables in alphabetical order, is this the correct method?

I am doubting it now because when I query from dba_tab_stats_history, some of the stats_update_time of different tables (especially big tables) overlap each other.

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