| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: parallel processes
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C35176.1F6C7C20
Content-Type: text/plain;
charset="iso-8859-1"
oramagic.
parallel_clause
BM_2050399Use the PARALLEL clause to change the default degree of parallelism for queries and DML on the index.
BM_2050400Restriction: You cannot specify this clause for an index on a temporary table.
BM_2057322
BM_2057320Note: BM_2057321
The syntax of the parallel_clause supersedes syntax appearing in earlier releases of Oracle. Superseded syntax is still supported for backward compatibility, but may result in slightly different behavior.
BM_2057343
BM_2057326
NOPARALLEL
BM_2057328Specify NOPARALLEL for serial execution. This is the default.
BM_2057332
PARALLEL
BM_2057334Specify PARALLEL if you want Oracle to select a degree of
parallelism equal to the number of CPUs available on all participating
instances times the value of the PARALLEL_THREADS_PER_CPU initialization
parameter.
BM_2057338
PARALLEL integer
BM_2057340Specification of integer indicates the degree of parallelism, which is the number of parallel threads used in the parallel operation. Each parallel thread may use one or two parallel execution servers. Normally Oracle calculates the optimum degree of parallelism, so it is not necessary for you to specify integer.
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/stat eme6.htm#2050398
-----Original Message-----
From: AK [mailto:oramagic_at_hotmail.com]
Sent: Wednesday, July 23, 2003 5:44 PM
To: Multiple recipients of list ORACLE-L
Subject: parallel processes
while rebuilding indexes i gave parrallel 2 . But I see there are four ora_p00 processes . ???
-ak
------_=_NextPart_001_01C35176.1F6C7C20
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4207.2601" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>
<H2 class=SH1><CODE><SPAN class=718055523-23072003><FONT size=2>oramagic.
</FONT></SPAN></CODE></H2>
<H2 class=SH1><FONT
face="Arial, Helvetica, sans-serif"><CODE></CODE></FONT> </H2>
<H2 class=SH1><FONT
face="Arial, Helvetica, sans-serif"><EM><CODE>parallel_clause</CODE>
</EM></FONT></H2><A name=2050399></A>
<P class=BP>Use the <CODE>PARALLEL</CODE> clause to change the default degree of
parallelism for queries and DML on the index. </P><A name=2050400></A>
<P class=BP><STRONG class=Bold>Restriction:</STRONG> You cannot specify this
clause for an index on a temporary table. </P><A name=2057322><STRONG
class=Bold></STRONG>
<DIV align=center>
<P>
<TABLE class=Note cellSpacing=0 cellPadding=0 width="80%" border=0>
<TBODY>
<TR class=Note>
<TD class=Note>
<HR>
<A name=2057320></A><FONT face="Arial, Helvetica, sans-serif"><STRONG
class=NH>Note:</STRONG></FONT> <A name=2057321></A>
<P class=NB>The syntax of the <EM><CODE>parallel_clause</CODE></EM>
supersedes syntax appearing in earlier releases of Oracle. Superseded
syntax is still supported for backward compatibility, but may result in
slightly different behavior.
<HR>
<TR class=Simple vAlign=top align=left>
<TD class=Simple><A name=2057326></A>
<P class=TS><CODE>NOPARALLEL</CODE> </P></TD>
<TD class=Simple colSpan=2><A name=2057328></A>
<P class=TS>Specify <CODE>NOPARALLEL</CODE> for serial execution. This is
the default. </P></TD></TR>
<P class=TS>Specify <CODE>PARALLEL</CODE> if you want Oracle to select a
degree of parallelism equal to the number of CPUs available on all
participating instances times the value of the
<CODE>PARALLEL_THREADS_PER_CPU</CODE> initialization
parameter. </P></TD></TR>
<P class=TS><STRONG><CODE>PARALLEL</CODE>
<EM><CODE>integer</CODE></EM> </STRONG></P></TD>
<TD class=Simple colSpan=2><A name=2057340></A>
<P class=TS><STRONG>Specification of <EM><CODE>integer</CODE></EM>
indicates the degree of parallelism, which is the number of parallel
threads used in the parallel operation. <FONT color=#ff0000>Each parallel
thread may use one or two parallel execution servers</FONT>. Normally
Oracle calculates the optimum degree of parallelism, so it is not
necessary for you to specify
<EM><CODE>integer</CODE></EM>.</STRONG> </P>
<P class=TS><STRONG></STRONG> </P>
<P class=TS><FONT face=Arial color=#0000ff
size=2>http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/stateme6.htm#2050398</FONT></P>
<P class=TS><FONT face=Arial color=#0000ff size=2></FONT> </P>
<P class=TS><FONT face=Arial color=#0000ff size=2></FONT> </P>
<P class=TS><FONT face=Arial color=#0000ff
size=2></FONT> </P></TD></TR></TBODY></TABLE></P></A></DIV>
 |
 |