Why set it at all - isn't the default value a good place to start? Perhaps useful: http://blogs.oracle.com/datawarehousing/2010/02/auto_dop_and_parallel_statemen.html On Tue, May 25, 2010 at 11:38 PM, Anupam Pandey <my.oralce@xxxxxxxxx> wrote: > How to decide on the values of the parameter PARALLEL_SERVER_TARGET. -- Regards, Greg Rahn http://structureddata.org -- //www.freelists.org/webpage/oracle-l