sqlplus 下的set autotrace 出来的执行计划不一定准确,可以使用下面的方法:
官方文档:DISPLAY_CURSOR Function:This table function displays the explain plan of any cursor loaded in the cursor cache. In addition to the explain plan, various plan statistics (such as. I/O, memory and timing) can be reported (based on the V$SQL_PLAN_STATISTICS_ALL VIEWS
).
--先查到v$sql的信息
select hash_value, child_number, sql_text
from v$sql
where sql_text like '%select * from test%';
select * from table(dbms_xplan.display_cursor(‘&hash_value’,‘&child_number’,'advanced'));
如:
select * from table(dbms_xplan.display_cursor(2373399249,0,'advanced'));