how to show SQL performance made by JDBC calls?
Hi,
I'm using Java in Eclipse to write JDBC calls to a Oracle DB 11gR2. I've been searching around on how to show the SQL performance and what I can find so far are all about setting timing, alter session trace=true or set serveroutput on. Because I don't have direct access to the underlying database, I need to know the performance of my JDBC calls without having to using PS/SQL or SQL Plus.
Is there simple SQL queries can help me get the performance stats? Like showing the execution time elapsed for the last executed SQL statement, so I can call it and print the output in the sysOut.
I'm using Java in Eclipse to write JDBC calls to a Oracle DB 11gR2. I've been searching around on how to show the SQL performance and what I can find so far are all about setting timing, alter session trace=true or set serveroutput on. Because I don't have direct access to the underlying database, I need to know the performance of my JDBC calls without having to using PS/SQL or SQL Plus.
Is there simple SQL queries can help me get the performance stats? Like showing the execution time elapsed for the last executed SQL statement, so I can call it and print the output in the sysOut.
0