I have a transaction called "updatePolicyStatus" whose response time is usually under a 3 seconds for many instances during a peak load. This transaction processes bunch of business rules and fires big set of SQLs to database. But during a peak load, 10% of the total transactions response time is going beyond a 60 seconds. When I look at individual queries they are fine. I am not quiet sure what else is causing the transaction to become slow once in a while? My database I/O, network, CPU and memory everything is fine tuned. Could you please let me know what else could be the bottleneck? My database is Oracle 11g and it has 100 Gigs of data.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top