Error: cannot fetch plan for statement_id 'PLUS22048358'

bjzt@treeminiSMX> SELECT COUNT(1) FROM KC_SPZJCK WHERE RQ >= TO_DATE(TO_CHAR(SYSDATE, 'YYYY-MM-DD'), 'YYYY-MM-DD')
  2  /


Execution Plan
----------------------------------------------------------
Error: cannot fetch plan for statement_id 'PLUS22048358'


Statistics
----------------------------------------------------------
      0  recursive calls
      0  db block gets
      13177  consistent gets
      0  physical reads
      0  redo size
    336  bytes sent via SQL*Net to client
    350  bytes received via SQL*Net from client
      2  SQL*Net roundtrips to/from client
      0  sorts (memory)
      0  sorts (disk)
      1  rows processed
      
hbjzt@treeminiSMX> explain plan for SELECT COUNT(1) FROM KC_SPZJCK WHERE RQ >= TO_DATE(TO_CHAR(SYSDATE, 'YYYY-MM-DD'), 'YYYY-MM-DD')
  2  /

Explained.

hbjzt@treeminiSMX> select * from table(dbms_xplan.display ) /
  2  
hbjzt@treeminiSMX>
hbjzt@treeminiSMX> select * from table(dbms_xplan.display )
  2  /

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------------------------------------
Error: cannot fetch last explain plan from PLAN_TABLE


hbjzt@treeminiSMX> select table_name ,LAST_ANALYZED,GLOBAL_STATS,STALE_STATS,USER_STATS ,STATTYPE_LOCKED from dba_tab_statistics where table_name = 'KC_SPZJCK' ;

TABLE_NAME               LAST_ANALYZED      GLOBAL_ST STALE_STA USER_STAT STATTYPE_LOCKED
------------------------------ ------------------ --------- --------- --------- ---------------
KC_SPZJCK               22-AUG-16      NO        NO          NO

统计信息正常

hbjzt@treeminiSMX> select SQL_ID,PLAN_HASH_VALUE,CHILD_NUMBER,OPERATION,OPTIMIZER,DEPTH,to_char(TIMESTAMP,'yyyy-mm-dd hh24:mi:ss') t  from v$sql_plan where sql_id ='60x32b2qx82au' ;

SQL_ID                    PLAN_HASH_VALUE CHILD_NUMBER OPERATION                OPTIMIZER        DEPTH T
--------------------------------------- --------------- ------------ ------------------------------ ---------- ---------- ---------------------------------------------------------
60x32b2qx82au                     4201141438        0 SELECT STATEMENT            ALL_ROWS        0 2016-08-22 06:52:48
60x32b2qx82au                     4201141438        0 SORT                        1 2016-08-22 06:52:48
60x32b2qx82au                     4201141438        0 INDEX                        2 2016-08-22 06:52:48

网上查原因是  current_schema =treemini_smx 不是同一个plan table 所致。
我当用户是sys ,通过alter session set current_schema=treemini_smx  ，切换至treemini_smx

如是我切换回来
alter session set current_schema=sys ;

hbjzt@treeminiSMX> explain plan for SELECT COUNT(1) FROM treemini_smx.KC_SPZJCK WHERE RQ >= TO_DATE(TO_CHAR(SYSDATE, 'YYYY-MM-DD'), 'YYYY-MM-DD')
  2  /

Explained.

hbjzt@treeminiSMX> select * from table(dbms_xplan.display )
  2  /

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 4201141438

--------------------------------------------------------------------------------------
| Id  | Operation          | Name         | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |          |       1 |       7 |    2980   (4)| 00:00:36 |
|   1 |  SORT AGGREGATE       |          |       1 |       7 |          |         |
|*  2 |   INDEX FAST FULL SCAN| PK_KC_SPZJCK |    1311 |    9177 |    2980   (4)| 00:00:36 |
--------------------------------------------------------------------------------------

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

   2 - filter("RQ">=TO_DATE(TO_CHAR(SYSDATE@!,'YYYY-MM-DD'),'YYYY-MM-DD'))

14 rows selected.

hbjzt@treeminiSMX> set autot traceonly
hbjzt@treeminiSMX>  SELECT COUNT(1) FROM treemini_smx.KC_SPZJCK WHERE RQ >= TO_DATE(TO_CHAR(SYSDATE, 'YYYY-MM-DD'), 'YYYY-MM-DD')
  2  /


Execution Plan
----------------------------------------------------------
Plan hash value: 4201141438

--------------------------------------------------------------------------------------
| Id  | Operation          | Name         | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |          |       1 |       7 |    2980   (4)| 00:00:36 |
|   1 |  SORT AGGREGATE       |          |       1 |       7 |          |         |
|*  2 |   INDEX FAST FULL SCAN| PK_KC_SPZJCK |    1311 |    9177 |    2980   (4)| 00:00:36 |
--------------------------------------------------------------------------------------

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

   2 - filter("RQ">=TO_DATE(TO_CHAR(SYSDATE@!,'YYYY-MM-DD'),'YYYY-MM-DD'))


Statistics
----------------------------------------------------------
      1  recursive calls
      0  db block gets
      13177  consistent gets
      0  physical reads
      0  redo size
    336  bytes sent via SQL*Net to client
    350  bytes received via SQL*Net from client
      2  SQL*Net roundtrips to/from client
      0  sorts (memory)
      0  sorts (disk)
      1  rows processed