Showing posts with label gather_index_stats. Show all posts
Showing posts with label gather_index_stats. Show all posts

Wednesday, October 28, 2015

Using DBMS_STATS to Gather Statistics

Collection of statistics on the database objects is very important for the performance of the database. DBMS_STATS package is used to collect these statistics.
To collect system statistics, use following procedure
SQL> exec dbms_stats.gather_system_stats

Popular Posts - All Times