Tuesday, November 30, 2010

Refresh TYPES are COMPLETE/FAST/ON COMMIT/ON DEMANDCouple of things you should do to make a mview to refresh in parallel:1.) Alter the master table to make sure it allows parallelism:alter table parallel (degree 4);To checkselect degree from dba_tables where table_name='';