ORACLE查询某个sqlid 执行历史时间

select a.sql_text        SQL语句,
       b.etime           执行耗时,
       c.user_id         用户ID,
       c.SAMPLE_TIME     执行时间,
       c.INSTANCE_NUMBER 实例数,
       u.username        用户名,
       a.sql_id          SQL编号
  from dba_hist_sqltext a,
       (select sql_id, ELAPSED_TIME_DELTA / 1000000 as etime
          from dba_hist_sqlstat
         where ELAPSED_TIME_DELTA / 1000000 >= 1) b,
       dba_hist_active_sess_history c,
       dba_users u
 where a.sql_id = b.sql_id
   and a.sql_id='24ambrj6zr7zc'
   and c.user_id = u.user_id
   and b.sql_id = c.sql_id
--and a.sql_text like '%IN%'
 order by SAMPLE_TIME desc, b.etime desc;