cannot fetch plan for SQL_ID: 5qgz1p0cut7mx, CHILD_NUMBER: 0

SQL> set serveroutput off    --一定要关
SQL>  select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED'));


PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID  5qgz1p0cut7mx, child number 0


BEGIN DBMS_OUTPUT.DISABLE; END;


NOTE: cannot fetch plan for SQL_ID: 5qgz1p0cut7mx, CHILD_NUMBER: 0
      Please verify value of SQL_ID and CHILD_NUMBER;
      It could also be that the plan is no longer in cursor cache (check v$sql_plan)




已选择8行。


SQL> select * from table(dbms_xplan.display_cursor(null,null,'allstats last'));


PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID  7xdg8akqchn1t, child number 1
-------------------------------------
 select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED'))


Plan hash value: 3713220770


---------------------------------------------------------------------
| Id  | Operation                         | Name           | E-Rows |
---------------------------------------------------------------------
|   0 | SELECT STATEMENT                  |                |        |
|   1 |  COLLECTION ITERATOR PICKLER FETCH| DISPLAY_CURSOR |     16 |
---------------------------------------------------------------------


Note
-----
   - cardinality feedback used for this statement
   - 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




已选择20行。


SQL>  select count(*) from t1 where object_id between :x and :y;


  COUNT(*)
----------
    145152


SQL> select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED'));


PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID  1ynfbm8a0p98u, child number 0
-------------------------------------
 select count(*) from t1 where object_id between :x and :y


Plan hash value: 1410530761


---------------------------------------------------------------------------------
| Id  | Operation              | Name   | Rows  | Bytes | Cost (%CPU)| Time     |
---------------------------------------------------------------------------------
|   0 | SELECT STATEMENT       |        |       |       |    91 (100)|          |
|   1 |  SORT AGGREGATE        |        |     1 |     5 |            |          |
|*  2 |   FILTER               |        |       |       |            |          |
|*  3 |    INDEX FAST FULL SCAN| IDX_T1 |   145K|   708K|    91   (3)| 00:00:02 |
---------------------------------------------------------------------------------


Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------


   1 - SEL$1
   3 - SEL$1 / T1@SEL$1


Outline Data
-------------


  /*+
      BEGIN_OUTLINE_DATA
      IGNORE_OPTIM_EMBEDDED_HINTS
      OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
      DB_VERSION('11.2.0.1')
      ALL_ROWS
      OUTLINE_LEAF(@"SEL$1")
      INDEX_FFS(@"SEL$1" "T1"@"SEL$1" ("T1"."OBJECT_ID"))
      END_OUTLINE_DATA
  */


Peeked Binds (identified by position):
--------------------------------------


   1 - :X (NUMBER): 0
   2 - :Y (NUMBER): 100000


Predicate Information (identified by operation id):
---------------------------------------------------


   2 - filter(:X<=:Y)
   3 - filter(("OBJECT_ID">=:X AND "OBJECT_ID"<=:Y))


Column Projection Information (identified by operation id):
-----------------------------------------------------------


   1 - (#keys=0) COUNT(*)[22]




已选择52行。