Please explain the difference between execution time and fetch time as it pertains to querying Oracle.
Exec time is when DbVisualizer requests the JDBC driver to execute the SQL until control is returned back to DbVisualizer.
Fetch time is when DbVisualizer requests the JDBC driver to fetch the result set until it is returned to DbVisualizer.
Hope this helps.
Thanks. So when the execution and fetch time reads "2.353/33.088 sec", 33.088 secs is the time the Oracle database took to run the query, right?
It is: Exec Time/Fetch Time.
Do you mean that the total time the Oracle database took to run the query is the two values, exec time and fetch time added together? In the example I gave, this would be 35.441 seconds.
Or do I misunderstand?
Exec + Fetch time is the total time used by the JDBC driver and database.