You can request information, such as the status of a materialized view, using the sa_materialized_view_info system procedure. See sa_materialized_view_info system procedure.
For more information statuses for materialized views, see View status.
Using the name of the materialized view, the options that were stored for it at creation time can be obtained from the SYSMVOPTION system view using a query. For example, to find the options for the EmployeeConfidential materialized view, you could execute the following statement:
SELECT option_name, option_value FROM SYSMVOPTION JOIN SYSMVOPTIONNAME WHERE SYSMVOPTION.view_object_id=( SELECT object_id FROM SYSTAB WHERE table_name='EmployeeConfidential' ) ORDER BY option_name;
To determine the list of views dependent on a materialized view, use the sa_dependent_views system procedure. See sa_dependent_views system procedure.
This information can also be found in the SYSDEPENDENCY system view. See SYSDEPENDENCY system view.