parallelizes execution of a single SQL query |
parallel execution carried out by concurrent Unix processes communicating via shared memory |
single Oracle instance sufficient - no PS necessary |
uses multiple CPUs on SMP architectures but can run on single CPU machines as well with modest performance benefits |
essential for Decision Support |
irrelevant for OLTP |