PARALLEL(x, y, z) with Partitioning

From: Domenic G. <domenicg_at_hotmail.com>
Date: 22 Oct 2003 07:14:40 -0700
Message-ID: <c7e08a19.0310220614.66b6e12f@posting.google.com>

I was looking through the Oracle docs just now and couldn't really find any detailed literature on exactly how parallel query works with partitions and RAC.

For example, let's say I have a 2-node RAC system and a very large table, range partitioned *evenly* into *4* partitions, each on separate disks. Each partition has, let's say 25 million records.

Will a query that does an FTS (no index) such as this ...

SELECT /*+ PARALLEL(table, 2, 2) */ COUNT(*) FROM ... WHERE ...

cause ...

RAC Node 1 to FTS partitions 1 & 2
RAC Node 2 to FTS partitions 3 & 4

so that there is no contention among the parallel query slave processes? How does parallel query intelligently divvy up work?

Domenic. Received on Wed Oct 22 2003 - 09:14:40 CDT