Why does partitioning help parallelism with RAC?
A.
The ability to do partition-wise joins reduces interconnect traffic.
B.
Partitioning allows you to split data storage across nodes.
C.
Partitioning reduces storage requirements.
D.
RAC will spawn additional parallel servers to meet the needs of requesting applications.
Explanation:
Partition-wise joins reduce query response time by minimizing the amount of data
exchanged among parallel execution servers when joins execute in parallel. This significantly
reduces response time and improves the use of both CPU and memory resources. In Oracle Real
Application Clusters (RAC) environments, partition-wise joins also avoid or at least limit the data
traffic over the interconnect, which is the key to achieving good scalability for massive join
operations.
Partition-wise joins can be full or partial. Oracle decides which type of join to use.
Reference: Oracle Database VLDB and Partitioning Guide, 11g Release 1 (11.1), 4 Partitioning
for Availability, Manageability, and Performance
A
This improved performance from using parallel execution is even more noticeable in Oracle Real Application Clusters configurations with internode parallel execution. Partition-wise joins dramatically reduce interconnect traffic. Using this feature is for large DSS configurations that use Oracle Real Application Clusters.
https://docs.oracle.com/cd/B10501_01/server.920/a96520/parpart.htm#98285