Fast refresh of aggregate-only materialized views – introduction

The same scripts investigates also disabling it by setting the undocumented parameter “_mav_refresh_opt”=32, but as always, ask Oracle Support first (also because there’s no official note explaining how it works on MOS, and I haven’t used it in production yet – since I actually discovered it about one week ago while preparing this post).

In the next post, we will examine the SUM scenario.

Page 3 of 3 | Previous page

2 comments on this post.
  1. Alberto Dell’Era’s Oracle blog » Fast refresh of aggregate-only materialized views with SUM – algorithm:

    [...] the general introduction to aggregate-only MVs we have seen how the refresh engine first marks the log rows, then inspects TMPDLT (loading its [...]

  2. Alberto Dell’Era’s Oracle blog » Fast refresh of aggregate-only materialized views with MAX – algorithm:

    [...] the general introduction to aggregate-only MVs we have seen how the refresh engine first marks the log rows, then inspects TMPDLT (loading its [...]

Leave a comment