Application responds FASTER with one of two RAC instances DOWN.
44428Sep 12 2006 — edited Nov 20 2006Anyone in the forum ever had a case where a twon-node RAC database's application responds fast when only one of instances are alive?
We have performed serveral tests, and the evidence is clear: if both instances are running, the response time is slower than with only one instance up. It doesn't matter which of the two that are up though.
The application is a GIS tool, which means that there may be lots of calculations in the database (I assume). I tried to increase the sga_target parameter slightly, but there was no change in response time. Unfortunately I cannot increase the memory as much as I want to because of hardware limitations. Currently the database has a sga_target of 1024M on both instances.
Any idea that could point me in the right direction would be appreciated.
- Vegard