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

From: Rich Jesse <>
Date: Wed, 2 Apr 2008 12:51:51 -0500 (CDT)
Message-ID: <29874.>

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


> 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 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.

Received on Wed Apr 02 2008 - 12:51:51 CDT

Original text of this message