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
