[11gR2]: alter session force PARALLEL QUERY to implement parallelism
I want to use parallelism (11gr2) as follow :
Trigger on logon :
execute immediate 'alter session force PARALLEL QUERY';
Any idea or remarks ? your opinion about parallel parameters ?
thanks.
GD.
PARALLEL parameters :
fast_start_parallel_rollback string LOW
parallel_adaptive_multi_user boolean TRUE
parallel_automatic_tuning boolean FALSE
parallel_degree_limit string 20
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 100
parallel_min_percent integer 0
parallel_min_servers integer 20
parallel_min_time_threshold string AUTO
parallel_server boolean FALSE