create table
PARALLEL ( DEGREE DEFAULT INSTANCES DEFAULT )
The Degree 'default value' is worked out thus :-
number of CPUs (cores) * number_of_thread_per_cpu (from v$parameter)
Instances is the number of nodes in the RAC that you want it to use
We hit a problem with a query going 'massively paralle' because the server had 16 cpus
, the number_of_thread_per_cpu was2 and the number of nodes was 2
We therefore ended up with something close to 64 parallel processes.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment