Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Parallel adaptive tuning!!

Re: Parallel adaptive tuning!!

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 16 Dec 2005 09:52:36 +0100
Message-ID: <dntuku$bke$1@news5.zwoll1.ov.home.nl>


Dexter wrote:
> 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
>

Are you running on a Superdome, single user? 64 parallel servers?

And an hint is an hint, not a directive.

- are table(s) involved parallel?
- are statistics up to date?
- how did you come to the conclusion, no slaves
  were being used?
- how did you generate the plan?
-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Fri Dec 16 2005 - 02:52:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US