Database Tuning (MOSC)

MOSC Banner

Parallel hint not working

edited Sep 26, 2012 6:07AM in Database Tuning (MOSC) 12 commentsAnswered

Hello.

We have a 2 node 10.2.0.4 RAC Database
We are trying to FORCE a parallel hint into one of our queries but for some reason
it is not performing parallel execution

Our init.ora settings related to parallel execution are as below

parallel_adaptive_multi_user         boolean     TRUE
parallel_automatic_tuning            boolean     FALSE
parallel_execution_message_size      integer     2152
parallel_instance_group              string
parallel_max_servers                 integer     8
parallel_min_percent                 integer     0
parallel_min_servers                 integer     0
parallel_server                      boolean     TRUE
parallel_server_instances            integer     2
parallel_threads_per_cpu             integer     2

Here is the query

SQL> Set autot trace

SQL> select /*+ parallel(app_ent, 4) */ * from app_ent

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