Hi,we are running IFSAPP10 on a Oracle 19c Enterprise Edition Database, using Oracle PDB concept.There, we ran into severe issues while people just have been trying to populate one single Customer Order. While observing the database sessions, we noticed that the query has been parallelized, divided into several sessions. Strangely, these sessions sometimes have been blocking each other. As a summary, instead of improving the performance with parallelism, it caused a severe performance drop.To solve it, we switched off parallel query mechanism by setting Oracle parameter “parallel_max_servers” to 1 (was 400).Is there a recommendation from IFS how these parameters “parallel_max_servers” and “parallel_min_servers” should be set? Or, more generally spoken, how parallel query feature should be set up together with IFS Applications?Please also share your experience with Oracle parallel query mechanism, and with which settings it runs best for you. Thank you!Wolfgang
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.