oracle的解析計劃,用Oracle解释计划

我试过这个：

select id from tag;

select * from table(dbms_xplan.display_cursor(format => 'ALLSTATS LAST'));但它给了我一个不属于最后声明的执行计划：

SQL_ID gypnfv5nzurb0, child number 0

-------------------------------------

select child_number from v$sql where sql_id = :1 order by

child_number

Plan hash value: 4252345203

--------------------------------------------------------------------------------------------------

| Id | Operation | Name | E-Rows | OMem | 1Mem | Used-Mem |

--------------------------------------------------------------------------------------------------

| 0 | SELECT STATEMENT | | | | | |

| 1 | SORT ORDER BY | | 1 | 2048 | 2048 | 2048 (0)|

|* 2 | FIXED TABLE FIXED INDEX| X$KGLCURSOR_CHILD (ind:2) | 1 | | | |

--------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

2 - filter(("KGLOBT03"=:1 AND INTERNAL_FUNCTION("CON_ID") AND

"INST_ID"=USERENV('INSTANCE')))

Note

-----

- Warning: basic plan statistics not available. These are only collected when:

* hint 'gather_plan_statistics' is used for the statement or

* parameter 'statistics_level' is set to 'ALL', at session or system level这显然是我没有得到的问题:(