|
Index >
ORACLE Server Parameters >
parallel_min_percent
parallel_min_percent
Oracle 11.1.0:
| Parameter 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 10.2.0:
| Parameter 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 10.1.0:
| Parameter 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:
| Parameter 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:
| Parameter 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:
| Parameter 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:
| Parameter 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 acquiredAction: 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.
| 
