time of Query Execution in Oracle ?

[kri shan]

How to find time of Query Execution in Oracle form system tables query ?

[Patryk Sosinski]

Hi, try:

select * from v$sql;

there are columns: FIRST_LOAD_TIME, ELAPSED_TIME and LAST_LOAD_TIME

[kri shan]

select * from v$sql

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

[Patryk Sosinski]

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?
order by last_load_time desc

I have just checked in my local db and it seems to be working properly