1、使用@?/rdbms/admin/sqltrpt.sql,按照提示输入sql_id,注意有会话卡死的风险,会话卡死后需要kill会话,否则以后对相关表的DDL都会hang
2、 DISPLAY_AWR
需要首先从AWR或者v$sqlarea或者DBA_HIST_SQLTEXT中获取sql_id
select sql_id,to_char(substr(sql_text,0,2000)) from dba_hist_sqltext where sql_text like '%EMP%';
select * from v$sqlarea where sql_text like '%emp%';
需要具有对DBA_HIST_SQL_PLAN和DBA_HIST_SQLTEXT等有select权限
然后
select * from table(dbms_xplan.display_awr('&sql_id'));