Gathering statistics local / remote 11gR2 database
After upgrade to 11g of a local database DB1 and a remote database DB2 , I have to gather dictionary + system + fixed tables statistics .
My application runs in DB1 use dblink to acceed remote database DB2.
On which database I have to gather statistics like:
-- Dictionary statistics
execute dbms_stats.gather_dictionary_stats();
execute dbms_stats.gather_system_stats('START');
-- System statistics
execute dbms_stats.gather_system_stats('STOP');
-- Fixed tables
execute dbms_stats.gather_fixed_objects_stats;
Best regards.
GD.