set linesize 200
set pagesize 200
column end_interval_time format a30
column sql_id format a15
select end_interval_time, a.instance_number,sql_id, plan_hash_value,BUFFER_GETS_DELTA,EXECUTIONS_DELTA,BUFFER_GETS_DELTA/EXECUTIONS_DELTA BUFFER_EXEC
from dba_hist_sqlstat a, dba_hist_snapshot b where a.snap_id = b.snap_id
and a.instance_number = b.instance_number and sql_id = &SQL_ID
and EXECUTIONS_DELTA > 0
order by 1
/
