Hi,i’ve done this, but only for the b2b portal. I did use IIS as a reverse proxy in between, so please look into this option. The internet and local FQDN’s do not match. We are still testing this but so far everything seems to work ok. Thanks,Kari
Hi, i hope your issues has been resolved. We went through something similar when upgrading from Oracle 11 → 12. Looking from your pfile you have optimizer_features_enable: 11.2.0.4 which did actually give some boost to performance. However after months of searching and comparing SQL executionplans we ended up with: optimizer_adaptive_features=FALSE optimizer_dynamic_sampling=2 The adaptive feature did not work for us at all so we disabled it. We have been running with these settings for a couple of years now and works ok. Big jobs like MRP now runs at same performance as with Oracle 11.
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.