Oracle 参数 PARALLEL_FORCE_LOCAL 官方解释，作用，如何配置最优化建议
本站中文解释
:
PARALLEL_FORCE_LOCAL参数指定是否在可以执行并行查询的情况下，是否在本地进行查询。
Oracle默认的行为，当设置参数PARALLEL_FORCE_LOCAL为真时，Oracle解析器将会尝试将“select”和“update/delete/ insert”查询拆分成本地可执行的查询，但是不会将拆分查询发送到其他数据库服务器执行。
要正确设置这个参数，可以使用以下SQL语句：
alter system set PARALLEL_FORCE_LOCAL = true;
这将会强制Oracle在本地服务器上进行查询拆分，而不是在可用的远程服务器上执行。
官方英文解释
PARALLEL_FORCE_LOCAL controls parallel execution in an Oracle RAC environment.
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Range of values |
|
|
Basic |
No |
By default, the parallel server processes selected to execute a SQL statement can operate on any or all Oracle RAC nodes in the cluster. By setting PARALLEL_FORCE_LOCAL to true, the parallel server processes are restricted so that they can only operate on the same Oracle RAC node where the query coordinator resides (the node on which the SQL statement was executed).
See Also:
Oracle Database VLDB and
Partitioning Guide for more information about this parameter
