RE: Parallel DELETE on Partitioned Table with Domain Index
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <greg@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 13 Feb 2009 14:16:43 -0500
Am I understanding this wrong? This is from the 10G docs.
UPDATE, MERGE, and DELETE operations are parallelized by partition or
subpartition. Update, merge, and delete parallelism are not possible within
a partition, nor on a nonpartitioned table. See "Limitation on the Degree of
Parallelism" for a possible restriction.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Greg Rahn
Sent: February 13, 2009 1:40 PM
To: ganstadba@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Parallel DELETE on Partitioned Table with Domain Index
On Fri, Feb 13, 2009 at 9:56 AM, Michael McMullen <ganstadba@xxxxxxxxxxx>
wrote:
>
> Would that run 8 threads on the single partition or just one with seven
> being idle. I always thought it was one thread per partition.
The 8 slaves would each be assigned granules from the single
partition, so they would all have work to process.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
