wood burning stoves 2.0*
The moose likes JDBC and the fly likes time of Query Execution in Oracle ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "time of Query Execution in Oracle ?" Watch "time of Query Execution in Oracle ?" New topic
Author

time of Query Execution in Oracle ?

kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1371
How to find time of Query Execution in Oracle form system tables query ?
Patryk Sosinski
Greenhorn

Joined: Sep 10, 2011
Posts: 18
Hi, try:



there are columns: FIRST_LOAD_TIME, ELAPSED_TIME and LAST_LOAD_TIME
kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1371
select * from v$sql


It is not always returning the latest last_load_time. Can i query any other table ?
Patryk Sosinski
Greenhorn

Joined: Sep 10, 2011
Posts: 18
kri shan wrote:

It is not always returning the latest last_load_time. Can i query any other table ?


Are you sure? It does not return the latest, so is it missing a record with latest log? Did you sorted the results?


I have just checked in my local db and it seems to be working properly
 
Consider Paul's rocket mass heater.
 
subject: time of Query Execution in Oracle ?
 
Similar Threads
database Issue: optimising views
time to execute query
Oracle Q in Java Interview
Oracle performance hit for 1 million record
Query Execution Time.