Parallel query test case doesn't seem to use parallel execution?
e are using 11.2.0.4.2 and the following test case query explain plan shows a query will run in parallel but i can't any evidence that it did so....
In SQLPLUS as new session-
show parameter parallel
fast_start_parallel_rollback string LOW
parallel_adaptive_multi_user boolean TRUE
parallel_automatic_tuning boolean FALSE
parallel_degree_limit string CPU
parallel_degree_policy string MANUAL
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 320
parallel_min_percent integer 0
parallel_min_servers integer 6
parallel_min_time_threshold string AUTO