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 query options for a table

Re: Parallel query options for a table

From: Oracle Help <oraclehelp_at_dbdomain.cc>
Date: Tue, 27 Apr 2004 16:12:27 -0700
Message-ID: <108tq6vcem12nfb@corp.supernews.com>


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

Original text of this message

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