how to know exact query execution time.

Hi,I want to know what is exact query execution time which excludes network access, constructing results. Please suggest me.Thanks in advance,Satish.G

[178 byte] By [satish_bg@rediffmail.coma] at [2007-11-27 4:59:42]

«« plz help me
»» paint component to image

# 1

satish,Have look into this document http://www.smckearney.com/oracle/timingsql.phpHope this will help you.......

hari_honeya at 2007-7-12 10:16:03 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

Not sure I know what you really want, but if this is a testing phase sort of thing and you are running on unix, there is the time command.

If you want something that is part of your application, you can run a timer in a separate Thread - for approximate time.

If you want more precise time, you can use java.util.Date - it has a method getTime(), which you can use before processing and again after processing and subtract the former from the later.

abillconsla at 2007-7-12 10:16:03 >

# 3

> which excludes network access

Any measurement you take in your Java/JDBC code will be the sum of the network access and the query execution time. You will not be able to separate the two numbers. If you want only the query execution time, you must measure that in your database server.

That makes your question a question about your database, not about Java or JDBC.

DrClapa at 2007-7-12 10:16:03 >

Database Connectivity

Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

how to know exact query execution time.

Database Connectivity Hot Topic

Database Connectivity

All Classified