PX Deq Credit: send blkd

From: Carlos <miotromailcarlos_at_netscape.net>
Date: Wed, 03 Oct 2007 00:53:37 -0700
Message-ID: <1191398017.565868.270760@o80g2000hse.googlegroups.com>

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. Received on Wed Oct 03 2007 - 02:53:37 CDT