CHECK PLAN HASH VALUE AND LOAD I/0 HISTORY USING SQLID

 CHECK PLAN HASH VALUE AND LOAD I/0 HISTORY USINF SQLID ======================================================

select ss.snap_id, ss.instance_number node, begin_interval_time, sql_id, plan hash_value, nv1 (executions_delta, 0) execs,

(elapsed_time_delta/decode (nv1 (executions_delta, 0), 0,1, executions_delta))/1000000 avg_etime, (buffer gets delta/decode (nv1 (buffer gets delta, 0),0,1, executions delta)) avg lio from DBA HIST SQLSTAT S, DBA HIST SNAPSHOT SS

where sql_id = 'dmhqu5dwb7akh'

and ss.snap id = S.snap id

and ss.instance_number = S.instance number

and executions delta > 0 order by 1, 2, 3;