When the user logs into our application, we call some stored procedures to get some data from the database, during that time the user request is not getting fullfilled and time outs.
Instance A in MMK was upgraded to 126.96.36.199, the one in B instance is still ver. 188.8.131.52.
Instance A without traffic shows minimum time per Oracle statement ~250 ms, spiking up to 2500 ms time to time (average at around 300 - 400 ms). If we bring traffic in, the time starts increasing constantly and when it reaches 10 - 14 seconds we start seeing timeouts. (That's not a surprise: new transactions have to wait for the executing ones).
B instance shows timing of 55 - 290 ms with or without traffic closer to the lower end - averaging at ~ 100 ms.