Usefulness of the "parallelism" parameter of DBMS_MVIEW.Refresh
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: