SQL Performance (MOSC)

MOSC Banner

11.2.0.4 on AIX 7.1 : Gathering dictionary , system and fixed tables statistics ?

edited May 29, 2015 10:02AM in SQL Performance (MOSC) 3 commentsAnswered

-- Under which conditions ?                                                                                                                                                       
execute dbms_stats.gather_dictionary_stats();                                                                                                                                               

-- Heavy workload                                                                                                                                     
EXEC DBMS_STATS.GATHER_SYSTEM_STATS('INTERVAL', interval => 15) ;     -- 15 minutes                                                                                                             
-- Fixed tables :                                                                                                                                                                             
--execute dbms_stats.gather_fixed_objects_stats;  

Finally , is it better to delete these statistics before gathering them again ?

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