Oracle Data Pump and Limitations On Parallel

[@comtmr]

During TTS , statistics part was taking too long, I even had to export som big tables stats in stage tables, move them and get stats via these stage tables. looking forward to see 23 performance. Very good presentation and sharing as always . Thanks a lot.

[@upgradenow]

Hi, You're right that statistics export and import takes a lot of time. Plus, it's something that you can do partially outside the maintenance window. So, we recommand that you use DBMS_STATS to move stats. Check these resources: dohdatabase.com/2023/12/18/how-to-export-and-import-statistics-faster-using-dbms_stats-in-parallel/ Regards, Daniel