How to find out how long does gatherstats run for each table
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.