select * from table(dbms_xplan.display);

Question

select * from table(dbms_xplan.display);
 
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
ERROR: cannot get definition for table 'PLAN_TABLE'
ORA-00980: synonym translation is no longer valid怎么解决？

Answer 1

把dbms_xplan.display里面的内容粘出来看看

Answer 2

  -- display from PLAN_TABLE
  function display(table_name   varchar2      default 'PLAN_TABLE',
                   statement_id varchar2      default null,
                   format       varchar2      default 'TYPICAL',
                   filter_preds varchar2      default null)
  return dbms_xplan_type_table
  pipelined;

Answer 3

SQL> select * from  table(dbms_xplan.display);PLAN_TABLE_OUTPUT
---------------------------------------------------------------------------------
Plan hash value: 1357081020--------------------------------------------------------------------------
| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |      |     7 |   224 |     3   (0)| 00:00:01 |
|   1 |  TABLE ACCESS FULL| TEST |     7 |   224 |     3   (0)| 00:00:01 |
--------------------------------------------------------------------------Note
-----PLAN_TABLE_OUTPUT
---------------------------------------------------------------------------------
   - dynamic sampling used for this statement已选择12行。SQL> alter system  flush  shared_pool;系统已更改。SQL> select * from table(dbms_xplan.dispaly);
select * from table(dbms_xplan.dispaly)
                    *
第 1 行出现错误:
ORA-00904: "DBMS_XPLAN"."DISPALY": 标识符无效SQL> explain   plan for  
  2  select * from test;已解释。SQL> select * from  table(dbms_xplan.display);PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------
Plan hash value: 1357081020--------------------------------------------------------------------------
| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |      |     7 |   224 |     3   (0)| 00:00:01 |
|   1 |  TABLE ACCESS FULL| TEST |     7 |   224 |     3   (0)| 00:00:01 |
--------------------------------------------------------------------------Note
-----PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------
   - dynamic sampling used for this statement已选择12行。SQL> 希望对你有帮助。可能是你没有进行查询语句查询过或者清除了共享池的缓存，导致共享池的sql语句缓存丢失。