How to monitor progress of dbms_stat.gather_database_stats
We are running oracle 11.2.0.3 rdbms on AIX 6. We are using datapump to import a full database copy of a 2.5TB database that was exported with the exclude=statistics parameter. ONce the database import completes I have been asked to run the dbms_stat.gather_database_stats on the database and was wanting to know if there is any way to monitor this process to understand how far along it is or if there is any way to estimate how long this will take?
I am guessing the only way to know is to run it and see but I am just getting pressure from mgmt to give an estimated time for this job to complete and I'm not sure what to tell them...