Index >
ORACLE Server Parameters >
parallel_min_percent
parallel_min_percent
Oracle 10.0.1:
Paramter Name: | parallel_min_percent
| Description: | minimum percent of threads required for parallel query
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | FALSE
|
Oracle 9.2.0:
Paramter Name: | parallel_min_percent
| Description: | minimum percent of threads required for parallel query
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | FALSE
|
Oracle 8.1.7:
Paramter Name: | parallel_min_percent
| Description: | minimum percent of threads required for parallel query
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | FALSE
|
Oracle 8.0.6:
Paramter Name: | parallel_min_percent
| Description: | minimum percent of threads required for parallel query
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | FALSE
|
Oracle 7.3.4:
Paramter Name: | parallel_min_percent
| Description: | minimum percent of threads required for parallel query
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | FALSE
|
Related Error Messages:
ORA-12827: insufficient parallel query slaves availableCause: PARALLEL_MIN_PERCENT parameter was specified and fewer than
minimum slaves were acquired
Action: either re-execute query with lower PARALLEL_MIN_PERCENT or
wait until some running queries are completed, thus freeing
up slaves
This parameter is documented in the
Oracle Server Reference Guide.
Search for more info about
[ parallel_min_percent ]
on the Oracle FAQ.
|