MV

1-Refresh MV
2-Show All information of Mview
3-Compile MV

---

1-Refresh MV

begin
dbms_refresh.refresh('"USER"."MV_1"');
end;

Example
begin
dbms_refresh.refresh('USER.MV_1');
end;

2-Show All information of Mview
It also show when is the last update on Mview also
select * from dba_mviews

3-Compile MV

ALTER MATERIALIZED VIEW X.MVNAME
   REFRESH FAST;