We are experiencing very poor performance on our live system and trying to understand what is causing it.
We can see that at database level users are logging in but we see many users are getting a collection of sessions, maybe as they move around screens and such like. We see that their 1st session appears to be locking their 2nd session and this manifests as a screen that freezes with the little ‘processing’ pop-up upon saving a record.
We also see one user’s session is locking out another user’s sessions
I wondered if anyone on here has experienced this and if it is possible to manage it
We’re on Apps 9 SP11 - 2 X Windows App Servers with 3 X Linux Oracle Database servers. All load balanced