Parallel adaptive tuning!!

From: Dexter <vikram_ramakrishnan_at_ieee.org>
Date: 15 Dec 2005 16:24:26 -0800
Message-ID: <1134692665.935456.181640@g47g2000cwa.googlegroups.com>

Hi,

I'm running oracle 9.2.0.5.0 on hp-ux.

SQL> sho parameter parallel

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

fast_start_parallel_rollback         string      LOW
log_parallelism                      integer     1
parallel_adaptive_multi_user         boolean     TRUE
parallel_automatic_tuning            boolean     TRUE
parallel_execution_message_size      integer     4096
parallel_instance_group              string
parallel_max_servers                 integer     64
parallel_min_percent                 integer     0
parallel_min_servers                 integer     4
parallel_server                      boolean     FALSE
parallel_server_instances            integer     1
parallel_threads_per_cpu             integer     1
recovery_parallelism                 integer     64

SQL> When i run a query with a parallel hint say /*+ parallel (a,8) */ , it doesnot seem to get any parallel slaves, though all parallel servers are idle.

When i check the run-time plan, it appears to have chosen parallel but there are no parallel slaves.

Can anybody point out what could be going wrong?

-Regards,

Vikram Received on Thu Dec 15 2005 - 18:24:26 CST