
12.3
Configuration Parameters 337
Chapter 12
Object Syntax
. Settings in object syntax such as CREATE TABLE
and CREATE MATERIALIZED VIEW statements.
The PARALLEL Hint
. Ultimately, parallelism is determined based
on CPU count and how much Oracle Database
thinks
the platform
can handle.
degree of parallelism = number of CPUs
* parallel threads per CPU
Note:
PARALLEL_THREADS_PER_CPU is a configuration parameter
(in the configuration parameter file).
12.3 Configuration Parameters
The following configuration parameters can affect parallel execution perfor-
mance directly, but you will want to make changes cautiously:
PARALLEL_MIN_SERVERS
. Causes ...