Re: best way to invoke parallel in DW loads?
From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 14 Sep 2009 15:23:57 -0700
Message-ID: <a9c093440909141523pfbcaa49vb3172d43068a1e6f_at_mail.gmail.com>
On Mon, Sep 14, 2009 at 1:50 PM, Jaromir D.B. Nemec <jaromir_at_db-nemec.com> wrote:
> My approach is to determine for the performance critical parts of the
> application the parallel degree explicit using hints. The degree is set
> based on the results of the step one.
Date: Mon, 14 Sep 2009 15:23:57 -0700
Message-ID: <a9c093440909141523pfbcaa49vb3172d43068a1e6f_at_mail.gmail.com>
On Mon, Sep 14, 2009 at 1:50 PM, Jaromir D.B. Nemec <jaromir_at_db-nemec.com> wrote:
> My approach is to determine for the performance critical parts of the
> application the parallel degree explicit using hints. The degree is set
> based on the results of the step one.
The good news is that Auto DOP in 11gR2 can automatically calculate
the DOP so no more tuning vodo should be required. One less knob for
the DBA/developer to have to mess with.
http://download.oracle.com/docs/cd/E11882_01/server.112/e10881/chapter1.htm#FEATURENO08700
Something to look forward to...
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 14 2009 - 17:23:57 CDT