Originally posted by Alec Lee:
What are the possible solutions I can use now?
- Batch JDBC calls to reduce number of queries.
- Make sure you aren't returning any unneeded fields in the result set
- Scale up (as you suggested)
- Add more hardware
- Any combination of these.
Would setting up RAC causes any change to my programs? Is it difficult to setup?
No RAC will not change your programs. The difficulty would depend on your familiarity with Oracle administration.