This content has been marked as final. Show 5 replies
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.
When asking any question, always please post the full 4 digit database version and the OS (and full version).
My question is why you bought a Ferrari with multiple motors, and want to exhaust only one of them.
Also, did you consult documentation, before asking this? There doesn't seem to be any parameter to arrange this.
Senior Oracle DBA
Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production
yes, i checked the doc, and no clause available.
the reason for Ferrary running on one node, the experience shows, if the parallel slaves run on one node, the
query (select) runs much faster, b/c the results dont have to be sent through the interconnect and dont have
to be merged from multiple nodes, this is a proven fact, so we like to apply the same approach, when a
mat view refreshed.
Could Oracle do it, may be some dynamic parameters have to be set for this session....? Just a thought....
This should do it,
alter session set parallel_force_local=true;
Oracle Certified Master DBA
THE really great finding!!!