Oracle Standard Edition 12.1 on Red Hat Linux 7
According to the documentation, parallel execution is enabled by default in Oracle SE 12.1. However, when looking at the database parameters, the following exists:
PARAMETER VALUE
--------- -----
Parallel execution FALSE
Is there an error in the documentation? Shouldn't this be set to TRUE.
What does this parameter refer to if not for enabling parallel execution?
If it needs to be set to TRUE, how to do so?
Best Answer
You say that VLDB and Partitioning Guide, Release 12.2
Parameters are described in the Database Reference.
But a lot of features are not possible in the Standard Edition. Either they cannot be enabled or are not allowed. Some of the features of Enterprise Edition need extra license if you use them.
More about which edition has which feature can be found in the Licensing Information User Manual