Viewing Materialized View Data Dictionary Views

In addition to using Enterprise Manager to view information about a materialized view site in a replication environment, you can also query the following data dictionary views using a tool such as SQL*Plus:

At the Materialized View Site:

DBA_SNAPSHOTS

DBA_REFRESH

DBA_REFRESH_CHILDREN

At the Master Site:

DBA_REGISTERED_SNAPSHOT

DBA_SNAPSHOT_LOGS