ALL PREVIOUS HISTORY RUN DETAILS OF SQL_ID FROM AWR

Multiple hash plans for sql id.
select
SQL_ID
, PLAN_HASH_VALUE
, sum(EXECUTIONS_DELTA) EXECUTIONS
, sum(ROWS_PROCESSED_DELTA) CROWS
, trunc(sum(CPU_TIME_DELTA)/1000000/60) CPU_MINS
, trunc(sum(ELAPSED_TIME_DELTA)/1000000/60)  ELA_MINS
from DBA_HIST_SQLSTAT
where SQL_ID in (
'SQL_ID') --repalce sqlid with your sqlid
group by SQL_ID , PLAN_HASH_VALUE
order by SQL_ID, CPU_MINS


ALL PREVIOUS HISTORY RUN DETAILS OF SQL_ID FROM AWR 
break off sdate
set lines 2000
set linesize 2000
col SDATE format a10
col STIME format a10
select to_char(begin_interval_time,'YYYY/MM/DD') SDATE,to_char(begin_interval_time,'HH24:MI')  STIME,s.snap_id,
        sql_id, plan_hash_value PLAN,
        ROUND(elapsed_time_delta/1000000,2) ET_SECS,
        nvl(executions_delta,0) execs,
        ROUND((elapsed_time_delta/decode(executions_delta,null,1,0,1,executions_delta))/1000000,2) ET_PER_EXEC,
        ROUND((buffer_gets_delta/decode(executions_delta,null,1,0,1,executions_delta)), 2) avg_lio,
        ROUND((CPU_TIME_DELTA/decode(executions_delta,null,1,0,1,executions_delta))/1000, 2) avg_cpu_ms,
        ROUND((IOWAIT_DELTA/decode(executions_delta,null,1,0,1,executions_delta))/1000, 2) avg_iow_ms,
        ROUND((DISK_READS_DELTA/decode(executions_delta,null,1,0,1,executions_delta)), 2) avg_pio,
        ROWS_PROCESSED_DELTA num_rows
from DBA_HIST_SQLSTAT S,  DBA_HIST_SNAPSHOT SS
where s.sql_id = '&sql_id'
and ss.snap_id  =S.snap_id
and ss.instance_number = S.instance_number
order by sdate,stime;
Enter value for sql_id: SQL_ID

=====

select /*+ MONITOR */

       e.ename,r.rname

from   employees  e

join   roles       r on (r.id = e.role_id)

join   departments d on (d.id = e.dept_id)

where  e.staffno <= 10

and    d.dname in ('Department Name 1','Department Name 2');

-- Get the SQL ID of the query we just executed

select prev_sql_id

from   v$session

where  sid=userenv('sid')

and    username is not null

and    prev_hash_value <> 0;

PREV_SQL_ID

-------------

SQL_ID

set linesize 250 pagesize 0 trims on tab off long 1000000

column report format a220

select

   DBMS_SQL_MONITOR.REPORT_SQL_MONITOR

        (sql_id=>'SQL_ID',report_level=>'ALL') report

from dual;