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

From: Dan Norris <>
Date: Mon, 31 Mar 2008 20:01:49 -0500
Message-ID: <>


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.


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 Mon Mar 31 2008 - 20:01:49 CDT

Original text of this message