Gather Fixed Object Stats Hangs on X$DURABLE_SHARDED_SUBS


On database, try to gather fixed table statistics with below command, it hangs at object “X$DURABLE_SHARDED_SUBS”.  Also hangs at select couint(*) from X$DURABLE_SHARDED_SUBS.


SQL>select count(*) from X$DURABLE_SHARDED_SUBS;


It is a bug for this issue, it is supposed to be fixed in 12.2.0.X.


Lock the statistics of this fixed table:

SQL>exec dbms_stats.lock_table_stats('SYS','X$DURABLE_SHARDED_SUBS');

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: