Database DataWarehousing (MOSC)

MOSC Banner

is dbms_mview.refresh assync or sync?

edited Apr 16, 2013 1:00AM in Database DataWarehousing (MOSC) 6 commentsAnswered

when I invoke dbms_mview.refresh('X')

Is the FAST REFRESH materialized view X guaranteed to be refreshed before the function returns?

This is my problem:

I have some "Real-Time" requirements. I am avoiding use ON COMMIT FAST REFRESH Materialized Views because it is impacting the transacation latency on the base tables.

Instead, I am using ON DEMMAND Fast refresh Materialized View + a refresher process which executes teh code bellow:

WHILE( true )
  LOOP
    dbms_mview.refresh('X');
    commit;
    dbms_lock.sleep( 0.01);
  end loop;

Of course, this will only works if  dbms_mview.refresh is synchronous.

If you guys can indentify any other problems with this "solution", please let me know.

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