Database DataWarehousing (MOSC)

MOSC Banner

MATERIALIZED VIEW 12.2

edited Oct 4, 2018 5:44AM in Database DataWarehousing (MOSC) 3 commentsAnswered

when I run this procedure:

EXEC DBMS_MVIEW.REFRESH('mv_test_view', method => '?');

...it completes after 291 seconds. But looking at the refresh stats:

SELECT * FROM DBA_MVREF_STATS WHERE mv_name = 'mv_test_view' ORDER BY refresh_id DESC;

... it shows only 189 seconds were taken.  Why the difference of ~100 seconds?

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