SQL Performance (MOSC)

MOSC Banner

Gathering statistics after upgrade to 11g

edited May 23, 2013 3:02AM in SQL Performance (MOSC) 2 commentsAnswered
 Hi ,
After upgrade from 10g to 11g , are you agree with me gathering statistics like this :

------------------------------------------------------------------------------------------------------------------
-- This procedure gathers statistics for dictionary schemas 'SYS', 'SYSTEM' and schemas of RDBMS components.
------------------------------------------------------------------------------------------------------------------
execute dbms_stats.gather_dictionary_stats(); -- just after upgrade to 11g.

------------------------------------------------------------------------------------------------------------------
--This procedure gathers system statistics.
------------------------------------------------------------------------------------------------------------------
execute dbms_stats.gather_system_stats('START');
-- 1  hour of workload
execute dbms_stats.gather_system_stats('STOP');


------------------------------------------------------------------------------------------------------------------
--This procedure gathers statistics for all fixed objects (dynamic performance tables).
------------------------------------------------------------------------------------------------------------------
execute dbms_stats.gather_fixed_objects_stats; -- while workload

Best regards.
GD.


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