Re: Parallel DELETE on Partitioned Table with Domain Index

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 13 Feb 2009 09:52:21 -0600
Message-ID: <ad3aa4c90902130752u64b81617he816e19b17064152_at_mail.gmail.com>

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
> http://hemantoracledba.blogspot.com
>
> "A 'No' uttered from the deepest conviction is better than a 'Yes' merely
> uttered to please, or worse, to avoid trouble."
> Mohandas Gandhi Quotes :
> http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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

Received on Fri Feb 13 2009 - 09:52:21 CST