Database DataWarehousing (MOSC)

MOSC Banner

Usefulness of the "parallelism" parameter of DBMS_MVIEW.Refresh

edited Jan 18, 2015 12:58PM in Database DataWarehousing (MOSC) 4 commentsAnswered

Hi All,

I'm not familiar with metaviews so I checked the DBMS_MVIEW package reference documentation to know what the parameters of the Refresh procedure were. I was pleased to see that there was one called "parallelism", and the following is said about it:

http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_mview.htm#i997194

0 specifies serial propagation.

n > 1 specifies parallel propagation with n parallel processes.

1 specifies parallel propagation using only one parallel process.


I used the Refresh procedure setting the "parallelism" parameter to 4, but it didn't make any difference, no parallel threads were launched. Ok, so it's not as trivial as it seems, so I searched ino the MOS KB and found this note:

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