Parallel query question

[Quoted] We've got an 8.0.5 instance (call it instance A) and a 7.3.4 instance (call it instance B) connected by a db link, and I've got a stored procedure in A that selects data from B and inserts it into A. Instance A is on a server that has 4 processors, and instance B is on a server that has 2 processors. Both instances have the Parallel Query Option enabled, and I'd like to try to take advantage of that fact in my stored procedure.

I've always used the rule of thumb that the degree of parallism in a 'parallel()' hint should be 1.5 times the number of processors. Since the code is stored in instance A, but selecting data from instance B, should my hint have a degree of parallelism of 1.5 * instance_A_processors == 1.5 * 4 = 6, or should I use a degree of parallelism of 1.5 * instance_B_processors == 1.5 * 2 == 3?

Thanks in advance for the help,
bob
bsullivn_at_home.com Received on Tue Aug 14 2001 - 05:36:09 CEST