如何看到真实的执行计划

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