title: How can I get the last execution time(timestamp) of an query in oracle
body: <p>It looks like the column Last_active_time is the last time that the query executed in an oracle DB, but it is date format.
  How to check the SQL executed history and order them by the last active or executed time?</p>
  <pre><code>SELECT a.SQL_ID,
    executions,
    a.LAST_LOAD_TIME,
    TO_CHAR(a.ELAPSED_TIME/1000/1000, '999,999,999.000')
    || ' s' AS TIME,
    a.MODULE,
    a.SQL_TEXT
  FROM v$sql a
  WHERE a.module IS NOT NULL
  AND a.module    = 'JDBC Thin Client'
  ORDER BY a.LAST_LOAD_TIME DESC
  </code></pre>