Materilized views tuning
HI,
We are having oracle 10.2.0.4
there are 27 materialized views in one schema and about 25 are refreshed (complete) daily and as a result about 90 GB of archive log is generating daily.
How can we reduce that? In one article I show the following command to reduce the redo
exec dbms_mview.refresh('<mview_name>','C',atomic_refresh=>FALSE)
but how can we do this for automatic refresh or is there any other way out?
thanks,
nk
We are having oracle 10.2.0.4
there are 27 materialized views in one schema and about 25 are refreshed (complete) daily and as a result about 90 GB of archive log is generating daily.
How can we reduce that? In one article I show the following command to reduce the redo
exec dbms_mview.refresh('<mview_name>','C',atomic_refresh=>FALSE)
but how can we do this for automatic refresh or is there any other way out?
thanks,
nk
0