PLSQL查看实际执行计划

1.需要查执行计划语句
explain plan for
update ic_month_handsign set ts='2018-11-07

2.执行计划查
select * from table(dbms_xplan.display)
SELECT plan_table_output FROM TABLE(DBMS_XPLAN.DISPLAY('PLAN_TABLE'));

二、查看实际的执行计划
update ic_month_handsign set ts='2018-11-07
select * from v$sql where sql_text like '% ic_month_handsign set ts='2018-11-07%'

通过sql_id 查询该语句的实际执行计划
select * from table(dbms_xplan.display_cursor('sql_id'))