Hello everyone,
i have range partitioned table 100% loaded In-Memory and i need to set manual DOP. I have tried without success:
ALTER TABLE my_table PARALLEL 8;
and doc says:
PARALLEL integer Specification of integer indicates the degree of parallelism, which is the number of parallel threads used in the parallel operation. Each parallel thread may use one or two parallel execution servers. Normally Oracle calculates the optimum degree of parallelism, so it is not necessary for you to specify integer.
Queries are only against this table i.e. there is no join or subselect using other table. My parallel settings:
db version: 12.1.0.2.0
NAME TYPE VALUE
-------------------------------------------------- ----------- ----------------------------------------------------------------------------------------------------
_parallel_statement_queuing boolean TRUE
fast_start_parallel_rollback string LOW
parallel_adaptive_multi_user boolean FALSE
parallel_automatic_tuning boolean FALSE
parallel_degree_level integer 100
parallel_degree_limit string CPU
parallel_degree_policy string AUTO
parallel_execution_message_size integer 16384
parallel_force_local boolean FALSE
parallel_instance_group string
parallel_io_cap_enabled boolean FALSE
parallel_max_servers integer 480
parallel_min_percent integer 0
parallel_min_servers integer 48
parallel_min_time_threshold string AUTO
parallel_server boolean FALSE
parallel_server_instances integer 1
parallel_servers_target integer 192
parallel_threads_per_cpu integer 1
recovery_parallelism integer 0
Thank you,
Jakub.