This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 and Relational Databases
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: 1396
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: 1396
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
 
Have you checked out Aspose?
 
subject: time of Query Execution in Oracle ?
 
It's not a secret anymore!