How do I see time spent during dbms_stats.gather_schema_stats?
Hello,
we use gather_schema_stats with following syntax:
execute dbms_stats.gather_schema_stats ( ownname => 'USER', estimate_percent => dbms_stats.auto_sample_size,options => 'GATHER', cascade => TRUE, granularity => 'ALL', method_opt => 'FOR ALL COLUMNS SIZE AUTO', degree => dbms_stats.default_degree, No_Invalidate => DBMS_STATS.AUTO_INVALIDATE );
We run this once a week and it takes some hours. I would like to see at which part (table) how much time is spent to analyze. Is there a detailed report where I can see or do I need to turn on something?
Thanks,
Sebastian