Oracle - single-processor systems parallel query posted by
Babu Kunwar
Can single-processor systems benefit from Parallel Query? Explain
A single processor is benifited but less as compared to multiple processor. As
processing SQL on a machine that has only a single processor, all SQL will
execute within a single process. As Parallel Query allows statements to be
divided and utilize multiple processes, resulting in quicker completion of the
statement so it is recomended to use multiple CPU. We need to set
PARALLEL_MAX_SERVERS to its minimum level inorder to use parallel queries in
the singlu CPU unit.
|
