Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Parallel query options for a table
Pedro is correct. In addition, configuring Oracle so that it can execute SQL
statements using parallel processing is straightforward. After setting the
three basic initialization parameters, existing database applications can
take advantage of parallel execution.
a.. The PARALLEL_MIN_SERVERS initialization parameter determines the
minimum number of parallel execution servers (slaves) to keep alive in the
pool of parallel servers.
b.. The PARALLEL_MAX_SERVERS initialization parameter determines the
maximum number of parallel execution servers to allow in the pool of
parallel servers.
c.. The PARALLEL_THREADS_PER_CPU initialization parameter determines an
instance's default degree of intra-parallelism.
Hope this helps get you on the right track.
oraclehelp_at_dbdomain.cc
Online- and CD-based Self Study Oracle Training
"Pedro Lopes" <pedro.lopes_at_netvisao.pt> wrote in message
news:newscache$5oluwh$oza$1_at_newsfront4.netvisao.pt...
> PARALLEL_SERVER is an Oracle Parallel Server parameter that specifies
> whether Oracle Parallel Server is enabled.
> Doesn't mean you can't use parallel query.
>
>
> Richard Elliott wrote:
>
> > If the init.ora configuration is :
> > Parallel Server = False
> > does it mean setting the instance and/or degree values of the parallel
> > query options for a table is moot ?
> >
> > Oarcle 8.1.6
> > Solaris 2.7
> >
> > Thanks in advance.
Received on Tue Apr 27 2004 - 18:12:27 CDT