Database Administration (MOSC)

MOSC Banner

[11gR2]: alter session force PARALLEL QUERY to implement parallelism

edited Jun 19, 2018 9:07AM in Database Administration (MOSC) 6 commentsAnswered
Hi ,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center