Re: Parallel DELETE on Partitioned Table with Domain Index
Date: Fri, 13 Feb 2009 09:52:21 -0600
I have seen that. Take a look at blockers/waiters and v$locks to see if contention is the problem.
On Fri, Feb 13, 2009 at 9:48 AM, Hemant K Chitale <hkchital_at_singnet.com.sg>wrote:
> 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.
> Any notes / stories that I can use ?
> Hemant K Chitale
> "A 'No' uttered from the deepest conviction is better than a 'Yes' merely
> uttered to please, or worse, to avoid trouble."
> Mohandas Gandhi Quotes :
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 13 2009 - 09:52:21 CST