Database DataWarehousing (MOSC)

MOSC Banner

SQL Parallel Execution

edited Oct 26, 2016 5:00AM in Database DataWarehousing (MOSC) 7 commentsAnswered

Hi All,

Greetings. Hope you are all doing great.

Our DB parameters are

_parallel_syspls_obey_force          boolean                        TRUE

fast_start_parallel_rollback         string                         LOW

parallel_adaptive_multi_user         boolean                        TRUE

parallel_automatic_tuning            boolean                        FALSE

parallel_degree_level                integer                        100

parallel_degree_limit                string                         CPU

parallel_degree_policy               string                         MANUAL

parallel_execution_message_size      integer                        16384

parallel_force_local                 boolean                        TRUE

parallel_instance_group              string

parallel_io_cap_enabled              boolean                        FALSE

parallel_max_servers                 integer                        128

parallel_min_percent                 integer                        0

parallel_min_servers                 integer                        0

parallel_min_time_threshold          string                         AUTO

parallel_server                      boolean                        TRUE

parallel_server_instances            integer                        5

parallel_servers_target              integer                        128

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