Re: What is the INSTANCES modifier of the PARALLEL clause?
From: Dan Norris <dannorris_at_dannorris.com>
Date: Mon, 31 Mar 2008 20:01:49 -0500
Message-ID: <47F1897D.7000704@dannorris.com>
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:
Date: Mon, 31 Mar 2008 20:01:49 -0500
Message-ID: <47F1897D.7000704@dannorris.com>
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:
-- http://www.freelists.org/webpage/oracle-l Received on Mon Mar 31 2008 - 20:01:49 CDTI'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.