Parallel hint not working
Hello.
We have a 2 node 10.2.0.4 RAC Database
We are trying to FORCE a parallel hint into one of our queries but for some reason
it is not performing parallel execution
Our init.ora settings related to parallel execution are as below
parallel_adaptive_multi_user boolean TRUE
parallel_automatic_tuning boolean FALSE
parallel_execution_message_size integer 2152
parallel_instance_group string
parallel_max_servers integer 8
parallel_min_percent integer 0
parallel_min_servers integer 0
parallel_server boolean TRUE
parallel_server_instances integer 2
parallel_threads_per_cpu integer 2
Here is the query
SQL> Set autot trace
SQL> select /*+ parallel(app_ent, 4) */ * from app_ent