Database DataWarehousing (MOSC)

MOSC Banner

Parallel query test case doesn't seem to use parallel execution?

edited Jan 15, 2015 10:01AM in Database DataWarehousing (MOSC) 1 commentAnswered

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

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