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怎么解决?
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
ERROR: cannot get definition for table 'PLAN_TABLE'
ORA-00980: synonym translation is no longer valid怎么解决?
-- 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;
---------------------------------------------------------------------------------
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语句缓存丢失。