Database Tuning (MOSC)

MOSC Banner

Executing DBMS_STATS.GATHER statistic objects (daily, weekly, monthly, etc...) command?

edited May 11, 2012 10:20AM in Database Tuning (MOSC) 6 commentsAnswered
Dear Support,

How oven i can execute the following commands for optimization purpose, in order gathering different types of statistic object (daily, weekly, monthly, etc...)?

-- exec dbms_stats.GATHER_FIXED_OBJECTS_STATS;
-- EXEC DBMS_STATS.GATHER_SCHEMA_STATS('SYS');
-- EXEC DBMS_STATS.GATHER_SCHEMA_STATS('SYSTEM');
-- exec dbms_stats.gather_dictionary_stats;

Another qutstion Q:

Can I also execute the following commands in order gathering SCHEMA owner statistic information, if yes how oven?

-- EXEC DBMS_STATS.GATHER_SCHEMA_STATS('DBSNMP');
-- EXEC DBMS_STATS.GATHER_SCHEMA_STATS('SYSMAN');
-- EXEC DBMS_STATS.GATHER_SCHEMA_STATS('MDSYS');

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