oracle通过sql_id获取执行计划

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'));