Performance - EBS (MOSC)

MOSC Banner

Executing DBMS_STATS.GATHER in order gathering different types of statistic object

edited May 10, 2012 5:20AM in Performance - EBS (MOSC) 3 commentsAnswered
Dear Support,

How oven i can execute the following commands 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?

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

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

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center