3
What tool can I use to evaluate the response time of a request (jdbc)
Ex:
query = "SELECT * FROM v$version WHERE banner LIKE '%Oracle%'";
ResultSet rs = stmt.executeQuery(query);
// linha de cima ⋀
// quanto tempo demorou nesse meio ?
// linha de baixo ⋁
rs.next();
In the log appears
15:58:35.175 INFO - 6. SELECT * FROM v$version WHERE banner LIKE '%Oracle%'; {executed in 1 ms}
In fact the query was executed with 1ms
but there is a gap
between running the query and loading this information.
What tool can I use to obtain such information?
In my case the database is in the cloud and the application in another node, what I need and the time it takes application and database to communicate (request/response). With this information your answer changes or remains the same? Thank you for your attention.
– Bruno Rozendo
@Brunorozendo If you want the total time, that is, including the time elapsed for Java to send the query to the database, the execution of the query and the time for the response from the database to Java, the solution is the same. On the other hand, if you want each individual value there the solution has to be at a lower level, for example, monitoring the network.
– utluiz
Thank you very much.
– Bruno Rozendo