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