SQL Performance (MOSC)

MOSC Banner

How do I see time spent during dbms_stats.gather_schema_stats?

edited Aug 12, 2015 12:19AM in SQL Performance (MOSC) 7 commentsAnswered

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

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