DBMS_STATS.GATHER_DATABASE_STATS

How to Gather Statistics on Database Level for Various Situations

by Ed Chen
November 19, 2016December 14, 2021

DBMS_STATS.GATHER_DATABASE_STATS We usually gather statistics of the database globally after data migration. The following examples are very practical in post-migration phase. Default You can do… Read More »

How to Choose the Most Needed to be Reorganized Tables

by Ed Chen
May 20, 2016March 29, 2018

We all know that table reorganization could improve the performance of DML on the tables. Your supervisor might ask you to do this action more… Read More »

How to Compare Two Databases After Migration (2/3) - Comparing Row Counts by Leveraging Statistics

by Ed Chen
December 24, 2012October 16, 2019

How to Compare Two Databases After Migration (1/3) - Comparing Initialization ParametersAfter a data migration, you might want to compare the number of rows of… Read More »