SQL Performance (MOSC)

MOSC Banner

Gathering statistics local / remote 11gR2 database

edited Jun 10, 2013 12:44AM in SQL Performance (MOSC) 5 commentsAnswered ✓
Hi,

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.

 

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