RE: Parallel DELETE on Partitioned Table with Domain Index

  • From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 13 Feb 2009 12:56:49 -0500

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.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Hemant K Chitale
Sent: February 13, 2009 10:48 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Parallel DELETE on Partitioned Table with Domain Index

I have an application that runs a DELETE statement on single 
Partition, but with PARALLEL 8.  The table also has  Domain Index -- 
I haven't been told if it is Partitioned or not.
The DELETE runs slowly.  I'm trying to convince the DBA / Developer 
(I have no access to the database) to run the DELETE without the PARALLEL.
(The PARALLEL 8 all operate within the *same* partition).

On a separate Test database without the Domain Index, the same 
DELETE, with PARALLEL, I have been told, runs very fast.  So, the 
team suspects the Domain Index.  I suspect contention on the Domain Index.


Other related posts: