aspose file tools*
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
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: 1373
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: 1373
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: time of Query Execution in Oracle ?