Re: Parallel procesing configuration.

Please,
don't do this!
If you have less than 16 concurrent active sessions, try to get a smaller system and save licenses.
If you have more, hope for the OS' scheduler!

Parallelism is great if you have single statements which runs much longer than any OLTP accept. (this is very general speaking, without any example.)

maybe you should go back to ordinary tuning questions:
what is 'slow'?
how fast would be 'fast'?

and: how many concurrent sessions/statements do you expect for this 'fast' performance?

starting with these questions you can on the one hand tune your statements and on the other calculate, how your CPUs will be utilized.

sorry, again no answer.


With today multicore servers, parallel query is very important to get the max performance from a server.
It´s common to see 16 core servers using only one of them…

Do you put some little parallelism on OLTP databases?
Where do you configure it? At table level? Instance level?


Please, share your kwnoledge, interesting docs, hints, etc about this complex topic.
This is my biggest question about Oracle configuration.

Other related posts: