获取ASH

-- 获取ASH
SELECT * FROM TABLE(dbms_workload_repository.ash_report_html(
     (select dbid from v$database), 1,
       SYSDATE - 10 / (24 * 60), 
       SYSDATE   -- end
     ));

select * from v$sql where SQL_ID='xxxxx'