I have been proposing that we increase our "THREADS" value in PAY_ACTION_PARAMETERS for Oracle EBS 12.1.3 from 8 to 16. We have 36 CPU on each DB node and the manager has 30 managers to run them... So we are good there.
I am wondering what the risks are if any? I am encountering pushback from people saying "It will make things slow" with no quantitative facts to back their claim. I on the other hand have tested some various processes and seen about 30% improvement (decrease) in run time (running a baseline with 8 threads, then another at 16 threads, then setting it back to 8 to confirm).
I am looking for other professionals opinions on this topic.
I am grateful for any feedback.
not easy to explain fast, depend of the system setup and database version
with a second database you have more safety and less performance in some situation
there is a lot of tranfert of block / object between 2 instance, that can bring more object lock and wait
that can explain why you see decrease performance
keep only one instance up and do a test