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

  • From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 2 Apr 2008 12:51:51 -0500 (CDT)

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.


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


Other related posts: