Parallel hint compounding

Jul 15, 2020 9:05AM

Quick questions

Do parallel hint compound, will it use the highest value hint or will it use the first hint found.

HPUX 3.x

oracle 12.2

parameters-

processes=1000

cpu_count=32

pga_aggregate_limit=10737418240

resource_manager_cpu_allocation=32

parallel_min_percent=0

parallel_min_servers=32

parallel_max_servers=827

parallel_instance_group=

parallel_execution_message_size=16384

parallel_degree_policy=MANUAL

parallel_adaptive_multi_user=FALSE

parallel_threads_per_cpu=2

pga_aggregate_target=5368709120

parallel_min_time_threshold=AUTO

parallel_degree_limit=CPU

parallel_force_local=FALSE

parallel_servers_target=512

parallel on table is 1

My test

select /*+ parallel (2)*/* from TEST where X in (select /*+

parallel(128) */ object_ID from dba_objects where object_ID like '10%')

SQL Performance (MOSC)