Database Administration (MOSC)

MOSC Banner

How gather schema stats work?

edited Feb 26, 2014 12:00PM in Database Administration (MOSC) 6 commentsAnswered

Hi Friends,

I have a question.

cat gather_schema_stats.sql

exec dbms_stats.GATHER_SCHEMA_STATS ('ADM', CASCADE=>TRUE);

exec dbms_stats.GATHER_TABLE_STATS (ownname=>'ADM',tabname =>'TIME');

exec dbms_stats.GATHER_TABLE_STATS (ownname=>'ADM',tabname =>'TIME_WRK');

exec dbms_stats.GATHER_TABLE_STATS (ownname=>'ADM',tabname =>'CS_POLL');

If I execute the above script, it will gather statistics for the ADM schema first. Then, will it gather statistics again for the tables or will it NOT? Those tables belong to the same schema ADM. Please clarify my doubt.

Thanks and Regards,

Su.

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