set linesize 150
set pagesize 2000
set long 3000
set ver off
set serveroutput on

begin
dbms_output.put_line('CONSULTA DE PLAN DE EJECUCIÓN EN AWR');
end;
/

--consulta de plan de ejecución en cache
--SELECT SQL_TEXT
--FROM DBA_HIST_SQLTEXT
--WHERE SQL_ID = '&1';

--select * from TABLE(dbms_xplan.display_cursor('&1', 0));
select * from TABLE(dbms_xplan.display_awr('&1', null, null, 'ADVANCED'));