get the execution plan for a sql id, the sql id taken from awr

select a.snap_id,a.begin_interval_time,a.end_interval_time, b.snap_id,b.sql_id,b.plan_hash_value,b.module,b.CPU_TIME_TOTAl,b.ELAPSED_TIME_TOTAL from DBA_HIST_SNAPSHOT a,dba_hist_sqlstat
b where a.snap_id=b.snap_id and  b.sql_id='9q3nbaq5a8x4r' order by a.begin_interval_time,a.end_interval_time;

select * from table(dbms_xplan.display_awr('9q3nbaq5a8x4r',null,null,'ALL'));