The moose likes JDBC and the fly likes time of Query Execution in Oracle ? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » JDBC
Reply 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: 1248
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: 1248
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
 
IntelliJ Java IDE
 
subject: time of Query Execution in Oracle ?
 
Threads others viewed
Oracle performance hit for 1 million record
database Issue: optimising views
Oracle Q in Java Interview
time to execute query
Query Execution Time.
developer file tools