having a mismatch between querying data and MV refresh — oracle-tech

    Forum Stats

  • 3,714,738 Users
  • 2,242,615 Discussions
  • 7,845,038 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

having a mismatch between querying data and MV refresh

Hans Langenberg
Hans Langenberg Member Posts: 10 Bronze Badge

Hi, Having a question.

We have a question about a Materialized View request.

We have a MV, and the query defining it is complex.

But when i run the query it takes seconds to give me all the rows, when i use the query to fill a "normal" table it take about twice the amount of time. But when i do a refresh of the MV it takes almost 10 minutes. (being hours on production with full data set)

Our database version is 12.1

The insert of the refresh holds the following hint:

/*+ BYPASS_RECURSIVE_CHECK APPEND */


TIA for any idea that might help to solve this problem,


HansL

Answers

Sign In or Register to comment.