PARALLEL_MAX_SERVERS, how it can impact my database
654189Jan 13 2009 — edited Jan 13 2009Hello, I´m trying to do a select with 200 parallels, using the parallel hint to do it. But my PARALLEL_MAX_SERVERS by default is 96, I can change this number , but I would like to know how this change can impact my database. I read in the Oracle Guide, that "If you set it too high, memory resource shortages may occur during peak periods, which can degrade performance.", but i want to know if it´s only the PGA or there´s another place.
The database is the 10g R2.
Thanks,