elmama
​A selection of topics on IT and its application to finance. 
​Send me your comments, questions ​or suggestions by clicking
h​ere


See what SQL has ran against the database


select
to_char(b.begin_interval_time,'dd-mon-yy hh24:mi:ss'),
a.sql_id,
a.plan_hash_value,
a.executions_delta,
upper(dbms_lob.substr(sql_text,4000,1)),
a.elapsed_time_delta/100000,
a.rows_processed_delta,
a.optimizer_cost,
a.sql_profile
from
dba_hist_sqlstat a,
dba_hist_snapshot b,
dba_hist_sqltext c
where a.sql_id = c.sql_id
and
        a.snap_id = b.snap_id
order by
        b.begin_interval_time