How to deal with statistics during migration

Burkinaone

Hello.

I am carrying a migration on from Oracle 11.2.0.4 to 19.3.

Source server is AIX 7.1. Destination is RHEL 7.

I am doing a schema export/import with datapump.

I am looking for the best way to deal with statistics:

-Systems statistics

-Dictionnary statistics

-Fixed objects statistics

-Databse statistics

Should I export/import them with datapump or dbms_stats or should I gather them on the new server?

Has anybody gone through this kind of migration?

Thanks.

Brett Calhoun

For the database statistics, I usually exclude them from the export and gather with DBMS_STATS after the import is complete.

Thanks,

Brett