Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Disable Parallel Query Execution - SE2

rlljorgeJan 31 2023 — edited Jan 31 2023

Hi,

Parallel Query Execution is not permitted under the terms of license in Oracle SE2.

In environments no multitenant I disabled this feature defining the initial parameter parallel_max_servers to 0, but in 19c SE2 multitennat isn't valid:

SYS@test AS SYSDBA> alter system set parallel_max_servers = 0;
alter system set parallel_max_servers = 0
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-12875: PARALLEL_MAX_SERVERS cannot be set to 0 in CDB system

So I defined the value to 1, but "Parallel SQL Query Execution" is detected in dba_feature_usage_statistics.

How to disable the parallel execution in database level in a CDB system ?

Regards,

Rodrigo

Comments
Post Details
Added on Jan 31 2023
7 comments
1,131 views