Re: Parallel update on non-partitioned tables - allowed at 10/11g?
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: kadmon@xxxxxxxxx
- Date: Mon, 16 Nov 2009 12:11:31 -0800
On Mon, Nov 16, 2009 at 5:30 AM, cam <kadmon@xxxxxxxxx> wrote:
> I know this issue comes up reasonably frequently in one form or another, but
> I would just like to get opinions on a simple question: is it possible to
> run parallel updates on a non-partitioned table at 10g and later?
Just some further clarification on PX limitations (dependent on what
version the table was created under):
For tables created prior to Oracle9i Database release version 9.0.1 or
tables that do not have the parallel DML itl invariant property, the
DOP is equal to the number of partitions or subpartitions. That means
that, if the table is not partitioned, the query runs in serial. To
see what tables do not have this property, issue the following
statement:
SELECT u.name, o.name FROM obj$ o, tab$ t, user$ u
WHERE o.obj# = t.obj# AND o.owner# = u.user#
AND bitand(t.property,536870912) != 536870912;
http://download.oracle.com/docs/cd/E11882_01/server.112/e10837/parallel.htm#VLDBG1531
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
