select sql_id, SQL_PLAN_HASH_VALUE, avg(secs), sum(secs) as secs, sum(cnt) as cnt, txt from (
select h.sql_id, h.SQL_PLAN_HASH_VALUE, h.sql_exec_id, h.sql_exec_start, max(h.sample_time),  to_char(max(sample_time),'SSSSS') - to_char(sql_exec_start,'SSSSS')  as secs,
count(*) cnt, max( trim(DBMS_LOB.SUBSTR (t.sql_text,4000)) ) as txt
 FROM   dba_hist_active_sess_history h 
left join dba_hist_sqltext t on t.sql_id = h.sql_id
where 
h.sample_time between to_date('13.07.16 21:31:09', 'dd.mm.yy hh24:mi:ss') and to_date('13.07.16 21:55:12', 'dd.mm.yy hh24:mi:ss')
group by h.sql_id, h.SQL_PLAN_HASH_VALUE, h.sql_exec_id, h.sql_exec_start
) group by sql_id, SQL_PLAN_HASH_VALUE, txt
order by cnt desc nulls last;

sql_id            SQL_PLAN_HASH_VALUE     avg(secs)    secs  cnt        txt
6hk0tngxa5nmq             0                 165       165    1     BEGIN REC_LOAD.Save(:load_id); END;