PARALLEL_MAX_SERVERS value

From: LS Cheng <exriscer_at_gmail.com>
Date: Tue, 25 Oct 2011 10:22:43 +0200
Message-ID: <CAJ2-Qb9KWakaZZO2ayd70SVsNPiDzj3hReC27Pc23g_1DZ_Zng_at_mail.gmail.com>

Hi
I have a developer who is keen reading documentation and then uses it to debate.

So in 11gR2 documentation,
http://download.oracle.com/docs/cd/E11882_01/server.112/e25513/initparams183.htm#i1132010, states that PARALLEL_MAX_SERVERS should be so high that seems unreasonable to me, in fact in the past I had to reduce PARALLEL_MAX_SERVERS to avoid RAC evictions and overloaded servers

The funny thing is that no where in oracle documentation states a recommended values (for both OLTP and DWH) except this URL, anyone know if there are any MOS note or OTN WP which state some decent recommended value for this parameter?

There is a MOS note which states recommended value for DWH is 10xcpu_count, too many IMHO.

Thanks

--

LSC
--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 25 2011 - 03:22:43 CDT