Re: PX Deq Credit: send blkd

On Oct 3, 2:53 am, Carlos <miotromailcar..._at_netscape.net> wrote:
> Hi all.
>
> This is Oracle 10.2.0.3 on Oracle Enterprise Linux. SGA: 1,5 Gb. PGA
> 512 Mb. On a bi-processor PIV machine.
>
> I'm running a process which has two MERGE /*+ parallel */ statements.
> The where's and clauses are almost the same (minor changes though).
> The first of them finishes in about 90 mins, and the second can last
> for 12 hours. (This is so strange to me: I would understand the two of
> them lasting more or less, but the almost the same). The tables merged
> have about 13 million rows each.
>
> Anyway: v$session_wait is telling me that the session is waiting for
> 'Deq Credit: send blkd' very frequently.
>
> I'm wondering about turning the query into Nested Loops. It should run
> slowlier, but...
>
> Suggestions?
>
> Thanks in advance.
>
> Cheers.
>
> Carlos.

You have explain plans for both of these statements? Please post them.

David Fitzjarrell Received on Wed Oct 03 2007 - 08:28:04 CDT