Oracle - Parallel Query and Parallel Server posted by
Babu Kunwar
Difference between Parallel Query and Parallel Server
Parallel query allows the large DML statement to be broken down into small
chunks so that the execution of the query can be faster. But Oracle Parallel
Server (OPS) option allows a database to be opened in shared mode. In shared
mode multiple instances of Oracle can mount the same database.
Oracle parallel query is based on the multiple nodes and multiple CPU
architecture where more than one CPU is engaged for query execution. But Oracle
Parallel Server runs on a shared disk cluster.
Oracle parallel query is used for the faster execution of the query when the
hardware of the system is heavily loaded. On the other hand Oracle Parallel
Server is used for load balancing for faster response.
The aim of parallel query is to execute a task more quickly. For that, the large
task is divided into smaller tasks executed concurrently on several nodes.
Whereas a parallel server is designed to run multiple instances that share a
single physical database. So when a parallel server is enabled, up to eight
instances mount the same database.
|
