Oracle Database Discussions

Hi all,

Can one say, in a general multi-processor & unix environment, what is the benefits/expenses when PARALLEL_MAX_SERVERS is set to 0. We find huge response time for query results and setting NO_PARALLEL hint on tables returns quick results. Are there any serious drawback for setting this parameter to zero in a multi-processor environment? I'd be willing to clarify further if need be.

I would appreciate if novice oracle toddlers keep their fiddling fingers off this question.

Regards,
...