I am connecting Tomcat to Oracle thru thin JDBC driver. The link between tomcat & oracle is now found to be the bottleneck - too many JDBC calls that could be handled by the network. What are the possible solutions I can use now?
Some suggest to use Oracle Real Application Cluster (RAC) to scale the db tier. I am new to this. Would setting up RAC causes any change to my programs? Is it difficult to setup? Also, are there any other alternatives?