查看带有A-TIME的执行计划

 

ALTER SESSION SET STATISTICS_LEVEL=ALL; ---再运行SQL

或者在SQL语句中加HINT： SELECT /*+ GATHER_PLAN_STATISTICS */ ....

 

SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL,'ALLSTATS LAST'));