--Top CPU Consuming SQL During A Certain Time Period
SELECT *
FROM
  (SELECT a.SQL_ID,
    SUM(a.CPU_TIME_DELTA      /1000000) CPU_TIME_SECS,
    ROUND(SUM(a.CPU_TIME_DELTA/1000000)/60,2) CPU_TIME_Mins,
    SUM(a.DISK_READS_DELTA), --Delta number of disk reads for this child cursor
    COUNT(a.SQL_ID),
    Min (s.BEGIN_INTERVAL_TIME),
    Max(s.END_INTERVAL_TIME),
    
    Sq.SQL_TEXT
  FROM DBA_HIST_SQLSTAT a,
    dba_hist_snapshot s,
    V$SQLAREA Sq
  WHERE s.snap_id = a.snap_id
  AND sq.SQL_ID   = a.SQL_ID
    --and s.begin_interval_time > sysdate -1
  AND a.SNAP_ID BETWEEN 4061 AND 4068
    --and EXTRACT(HOUR FROM S.END_INTERVAL_TIME) between 9 and 11
  GROUP BY a.SQL_ID,
    Sq.SQL_TEXT
  ORDER BY CPU_TIME_SECS DESC
  )
WHERE rownum <= 1

Output:

SQL_ID        CPU_TIME_SECS CPU_TIME_MINS COUNT(A.SQL_ID) MIN(S.BEGIN_INTERVAL_TIME)  MAX(S.END_INTERVAL_TIME) 
------------- ------------- ------------- --------------- --------------------------- ---------------------------
9wf6xgh5y557p    2072,87889         34,55               5 14.03.14 01:00:27,817000000 14.03.14 06:00:34,599000000

Select Min(ash.sample_Time), Max (Sample_Time), Round (Count (*)/60, 2) Mins
From V$ACTIVE_SESSION_HISTORY ash
Where ash.SQL_ID  = '9wf6xgh5y557p'
 --and ash.SNAP_ID BETWEEN 4062 AND 4068
 and ash.sample_time >= to_date('14-03-2014 00:46:01','dd-mm-yyyy hh24:mi:ss') --sample_time = '08.03.14 18:06:34,335000000'
 and ash.sample_time <= to_date('14-03-2014 07:35:01','dd-mm-yyyy hh24:mi:ss') --sample_time = '12.03.14 13:48:50,138000000'--
 --Order By ash.sample_Time
;

MIN(ASH.SAMPLE_TIME)        MAX(SAMPLE_TIME)                  MINS
--------------------------- --------------------------- ----------
14.03.14 01:17:57,468000000 14.03.14 05:31:21,880000000     227,02