Tag: SYS.MVREF$_CHANGE_STATS

While trying to drop a materialized view, the session waits on the following query: This wait is due to usage tracking enabled for MVIEW operations…