996538 wrote:post SQL & results that show PARALLEL slaves run on different nodes.
greatly appreciate your help.
how to limit the execution the following query to one instance, to avoid going through the interconnect in a RAC DB,
exec dbms_mview.refresh('schema.mat_view',parallelism=>10 );
in another words, to allow all the parallel slaves to be run on one node.