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.