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