DBA_MVIEW_DETAIL_SUBPARTITION displays freshness information for all materialized views in the database, with respect to a PCT detail subpartition. Its columns are the same as those in "ALL_MVIEW_DETAIL_SUBPARTITION".
DBA_MVIEW_DETAIL_SUBPARTITION
Scripting on this page enhances content navigation, but does not change the content in any way.