RE: Parallel DELETE on Partitioned Table with Domain Index

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Fri, 13 Feb 2009 12:56:49 -0500
Message-ID: <BAY141-DAV1383CAC3A441294E3DFE9A6B80_at_phx.gbl>
Message-ID: <F626BA5035746548AF2DF3E71FEB5257220D896485_at_MBX01.bell.corp.bce.ca>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale
Sent: February 13, 2009 10:48 AM
To: oracle-l_at_freelists.org
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.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 13 2009 - 11:56:49 CST

This message: [ Message body ]
Next message: Yong Huang: "RE: deadlock trace file in weblogic environment"
Previous message: Li Li: "Re: DBMS_STATS.GATHER_TABLE_STATS and ANALYZE TABLE"
In reply to: Hemant K Chitale: "Parallel DELETE on Partitioned Table with Domain Index"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message