Re: Parallel adaptive multiuser

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: oralrnr@xxxxxxxxx
  • Date: Fri, 9 Sep 2011 22:01:43 -0700

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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: