Message from: Garivaldo
How to get parallel to use multiple instances by using degree option. Let’s
assume that I have a 2 node rac database.
Option 1 - If you don’t specify a degree it does it , but it creates 2 *
cpu_count sessions * parallel_threads_per_cpu on each instance – which may be
an overkill
Option 2 - If you use a degree it seems to just go to one instance only.
Option 3 – This should open up 8 sessions on both nodes both does not.
-
Select /*+ PARALLEL */ -
-
Select /*+ PARALLEL(4) */ - Only goes to one session
-
Select /*+ PARALLEL(4,2) */ - Doesn’t seem to work the way I expected
it
Historical Messages
Author: Garivaldo
Date: Fri Sep 30 10:51:12 PDT 2011
How to get parallel to use multiple instances by using degree option. Let’s
assume that I have a 2 node rac database.
Option 1 - If you don’t specify a degree it does it , but it creates 2 *
cpu_count sessions * parallel_threads_per_cpu on each instance – which may be
an overkill
Option 2 - If you use a degree it seems to just go to one instance only.
Option 3 – This should open up 8 sessions on both nodes both does not.
-
Select /*+ PARALLEL */ -
-
Select /*+ PARALLEL(4) */ - Only goes to one session
-
Select /*+ PARALLEL(4,2) */ - Doesn’t seem to work the way I expected
it
__