Re: What is the INSTANCES modifier of the PARALLEL clause?

Thanks Dan (and Greg)! That answers it perfectly.

Rich

> See
> Note:260845.1 Old and new Syntax for setting Degree of Parallelism
>
> In short, I don't think INSTANCES matters any more as it is internally
> converted to the new syntax (that doesn't include instances) anyway.
>
> Dan
>
> Rich Jesse wrote: I'm looking to implement parallelism for our largest
> tables in 10.1.0.5.0 on AIX in order to more fully utilize our SAN. While
> continuing testing with various parameters, I've been seeing that there is
> an INSTANCES qualifier of the PARALLEL clause in the ALTER TABLE statement.

--
http://www.freelists.org/webpage/oracle-l