SELECT b.sql_id, a.module, a.snap_id, a.instance_number, a.elapsed_time_total,
       a.executions_total, b.sql_text
  FROM dba_hist_sqlstat a, dba_hist_sqltext b
WHERE a.elapsed_time_total / a.executions_total / 1000000 >= 10
   AND a.executions_total >= 1
   AND a.sql_id = b.sql_id