oramagic.
parallel_clause
Use the PARALLEL clause to change the default degree of
parallelism for queries and DML on the index.
Restriction: You cannot specify this
clause for an index on a temporary table.
Note:
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.
|
NOPARALLEL
|
Specify NOPARALLEL for serial execution. This is
the default. |
PARALLEL
|
Specify 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. |
PARALLEL
integer
|
Specification 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/stateme6.htm#2050398
|
while rebuilding indexes i gave parrallel 2 . But I
see there are four ora_p00 processes . ???
-ak
|