Re: Parallel adaptive multiuser
From: Greg Rahn <greg_at_structureddata.org>
Date: Fri, 9 Sep 2011 22:01:43 -0700
Message-ID: <CAGXkmiuy=GOdYoyzCV9ngVCfGAQhF0fORY+Z45y8fZnj_7PfKA_at_mail.gmail.com>
If you check the docs, you will see PARALLEL_ADAPTIVE_MULTI_USER is still there even in 11.2:
http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/initparams174.htm#REFRN10154
Date: Fri, 9 Sep 2011 22:01:43 -0700
Message-ID: <CAGXkmiuy=GOdYoyzCV9ngVCfGAQhF0fORY+Z45y8fZnj_7PfKA_at_mail.gmail.com>
If you check the docs, you will see PARALLEL_ADAPTIVE_MULTI_USER is still there even in 11.2:
http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/initparams174.htm#REFRN10154
My advice would to not use it (set it to false), but rather use db resource manager and/or auto DOP with parallel statement queuing (11.2) to control overallocation of parallel execution.
On Fri, Sep 9, 2011 at 1:57 PM, Orlando L <oralrnr_at_gmail.com> wrote:
> List,
> With the v10 and v11, is the above parameter being used in DW environments,
> or has it been replaced by something newer.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Sat Sep 10 2011 - 00:01:43 CDT