Oracle 8i hidden materialized views parameters Don Burleson

Note: Oracle hidden parameters are undocumented and unsupported by Oracle.
Make sure that you thoroughly test all hidden parameters before placing them in your production environment.

Parameter Name                            Description

----------------------------------------- ----------------------------------------------------------------

_mv_refresh_delta_fraction                delta mv as fractional percentage of size of mv

_mv_refresh_eut                           refresh materialized views using EUT(partition)-based algorithm

_mv_refresh_new_setup_disabled            materialized view MV refresh new setup disabling

_mv_refresh_selections                    create materialized views with selections and fast refresh

_mv_refresh_use_stats                     pass cardinality hints to refresh queries

_mav_refresh_consistent_read              refresh materialized views using consistent read snapshot

_mav_refresh_double_count_prevented       materialized view MAV refreshes avoid double counting

_mav_refresh_opt                          optimizations during refresh of materialized views

_mav_refresh_unionall_tables              # tables for union all expansion during materialized view refresh