• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

time of Query Execution in Oracle ?

 
kri shan
Ranch Hand
Posts: 1467
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How to find time of Query Execution in Oracle form system tables query ?
 
Patryk Sosinski
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, try:



there are columns: FIRST_LOAD_TIME, ELAPSED_TIME and LAST_LOAD_TIME
 
kri shan
Ranch Hand
Posts: 1467
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
select * from v$sql


It is not always returning the latest last_load_time. Can i query any other table ?
 
Patryk Sosinski
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic