Database Tuning (MOSC)

MOSC Banner

refresh materialize view takes a lot of time

when refreshing materialized view - it takes 11 hours but select from underlined view takes about 20seconds, the INSERT /*+ BYPASS_RECURSIVE_CHECK */

INTO my_mat_view takes forever

Tried atomic_refresh => FALSE but it does not help

Oracle database 19.33

Any ideas?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center