Database DataWarehousing (MOSC)

MOSC Banner

Parallel refresh of materialized viev

edited Feb 15, 2012 7:49PM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hello all

I have a matrialized view that I would like to do a complete refresh on in parallel. I have a parallel hint on the select-statement and the mv is created with parallel. When I create the mv with build immediate, both the select and load happens in parallel. When I create with build deferred and then do a refresh, then only the select is done in parallel. I have tried 'alter session enable parallel dml' and even 'alter session force parallel dml parallel 8' and also using the parallelism-parameter on the dbms_Mview.refresh call. No luck, the insert is done serially.

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