Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center