Tag: DBMS_STATS.GATHER_DICTIONARY_STATS is Stuck on WRH$_ACTIVE_SESSION_HISTORY and is Taking a Very Long Time

Hey everyone, Hope you’re doing good. We have a client that has a database used for a SAP BI solution (BW – Business Warehouse), which had stale statistics for dictionary…