DBMS_STATS.GATHER_DATABASE_STATS

Gather Database Statistics Examples

by Ed Chen
November 19, 2016May 16, 2023

How to Use 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.… 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, 2012June 6, 2023

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

JavaScript is not enabled. Please enable it and reload the page.