Database Administration (MOSC)

MOSC Banner

How affect to db server if analyzing table and index every day ?

edited Mar 16, 2012 5:35AM in Database Administration (MOSC) 5 commentsAnswered
 Hi all,

   I used oracle version 9.2.0.4 on Unix

   If I need to compute size of objects in database and use this information to monitor how big is one table or index might be a candidate for moving or rebuilding in order to improve performance
   The first, I must run ANALYZE such: 

ANALYZE TABLE TEST.T2 COMPUTE STATISTICS;
   
   Or:
EXEC DBMS_STATS.gather_table_stats('TEST', 'T2');

   But I want ask just about analyze table object: If every day, I analyze some tables, this work affect to perfomance of DML ? About index, every week I scheduled shrink and analyze index.

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