Re: PX Deq Credit: send blkd

From: Martin Klier <>
Date: Tue, 23 Sep 2008 14:13:47 +0200
Message-ID: <>

Hi Chris,

Christian Antognini schrieb:
> Which is the definition of the table KLM_TEST? I ask because I noticed
> that the query contains some hidden columns and also a call to
> SYS_OP_NOEXPAND (see below). It might be that you are processing some
> data not supported by PX.

This hint was great: There has been a user defined object type in the table definition.
This prevented the table from parallelizing, as well as it slowed down any simple select on it.

You know, what I posted here have been tests to simplify the case described in the very beginning of this thread, you remember the huge merge? So, furthermore, the target table of my merge has had a trigger specified on written columns, what prevents DML parallelization as well.

The link for infos about parallel DML is:

Chris, Ian, William and all other contributors to this thread: Thanks a lot - it's a great thing that you are spending your valuable time for shooting other people's trouble!

Best regards
Martin Klier

Usn's IT Blog for Linux, Oracle, Asterisk

Received on Tue Sep 23 2008 - 07:13:47 CDT

Original text of this message