exec dbms_stats.gather_fixed_objects_stats ;
On a 19.16 on Solaris Sparc64
Running:
exec dbms_stats.gather_fixed_objects_stats ;
This is now running for 25 hours on the database.
Question : is that an issue ? How long can it run ?
I ran it on 2 different databases (that have the same source database) and they have a similar behaviour, although not that extreme on the other one.