Gathering statistics after upgrade to 11g
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.
0