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. -- //www.freelists.org/webpage/oracle-l